SQL TOP N 페이징예문

SELECT * FROM cart;
CREATE TABLE IOT2_TEST25 --회원관리
  (
    ID           NUMBER(8),
    PW           VARCHAR2(10),
    name         VARCHAR2 (8),
    age          NUMBER,
    grade        VARCHAR2(20),
    company_name VARCHAR2(20),
    addr         VARCHAR2(50),
    phone        VARCHAR2(15),
    hp           VARCHAR2(20)
  );
-- iot2_test25; 테이블 만들기
SELECT * FROM iot2_test25;
-- iot2_test25; 확인하기

insert into iot2_test25
values(5,'aaa','xa',10,'a','asd','인천','02-111-2222','010-5555-5555');
-- iot2_test25; 데이터 입력(6개 반복입력)

select * id,pw
from (id,pw from iot2_test25)
where rownum<=3;
select rm, id, pw, name, age, grade, company_name, addr, phone, hp
from(select rownum rm, id, pw, name, age, grade, company_name, addr, phone, hp
from(select * from iot2_test25 order by id desc)
)
--where rownum<=3;(1번부터 3번까지)
where rm between 3 and 6;--(3번부터 6번까지)
--TOP N / iot2_test25 예문