Oracle | 페이지 나누기 쿼리
페이지 정보
작성자 박석영 작성일21-06-09 09:40 조회353회 댓글0건관련링크
본문
SELECT LIBCODE,LIBNAME,REQ_DATE,SERVERIP, GRADE, POINT
FROM
(
SELECT SEQ ,LIBCODE ,LIBNAME ,REQ_DATE,SERVERIP, GRADE , POINT
FROM
(
SELECT ROWNUM AS SEQ, LIBCODE, LIBNAME, REQ_DATE,SERVERIP, GRADE, POINT
FROM
(
SELECT LIBCODE,LIBNAME,TO_CHAR(REG_DATE,'YYYY-MM-DD HH24:MI:SS') AS REQ_DATE ,SERVERIP, GRADE, POINT
FROM MSG_MEMBER
WHERE LIBCODE IS NOT NULL
ORDER BY POINT desc
)
)
WHERE SEQ >= 1
)
WHERE ROWNUM <= 10
FROM
(
SELECT SEQ ,LIBCODE ,LIBNAME ,REQ_DATE,SERVERIP, GRADE , POINT
FROM
(
SELECT ROWNUM AS SEQ, LIBCODE, LIBNAME, REQ_DATE,SERVERIP, GRADE, POINT
FROM
(
SELECT LIBCODE,LIBNAME,TO_CHAR(REG_DATE,'YYYY-MM-DD HH24:MI:SS') AS REQ_DATE ,SERVERIP, GRADE, POINT
FROM MSG_MEMBER
WHERE LIBCODE IS NOT NULL
ORDER BY POINT desc
)
)
WHERE SEQ >= 1
)
WHERE ROWNUM <= 10
[주소복사] https://www.goodsweb.kr/?u=D4102A9B
SNS 알리기
핀터레스트
텔레그램로
블로그로
페이스북
트위터
카카오스토리
카톡 공유
관련 블로그
로딩중