Oracle分頁
查詢語句:
select * FROM A_WECHAT WHERE 1=1
查詢記錄總數:
SELECT nvl(count(*),0) as totalNum
FROM (
select * FROM A_WECHAT WHERE 1=1
) where 1=1
分頁:
SELECT
*
FROM
(
SELECT
TIN.*, ROWNUM AS rowno
FROM
(
select * FROM A_WECHAT WHERE 1=1 order by OPENID desc
) TIN
WHERE
ROWNUM <= 50 ) TOUT
WHERE
TOUT.rowno >= 1