Oracle分页查询SQL
SELECT
B.*
FROM
(
SELECT ROWNUM
RU,
A.*
FROM
( SELECT
W.UNISCID, W.ERR_REMARK, W.CREATE_TIME,W.ERR_COUNT
FROM LOG_DEAL_E_BASE W
WHERE W.UNISCID='91430100MAC285T02E'
ORDER BY CREATE_TIME DESC ) A
WHERE
ROWNUM <= 1000
) B
WHERE
RU >= 1;

浙公网安备 33010602011771号