oracle如何使用rownum查1000-2000条之间的记录

[嘉友云阁]

SELECT '573' CITY_ID,CASE WHEN SF.FDBH=2 THEN '11943000' WHEN SF.FDBH=7 THEN '11943001' WHEN SF.FDBH=12 THEN '11943002' WHEN SF.FDBH=9 THEN '11943003' WHEN SF.FDBH=11 THEN '11943004' ELSE '' END JDFDBH,JD.JDSKU,SF.LSDJ AS LSDJ,' ' SCJ
FROM SPXX_JB S, SPXX_JD JD, SPXX_FD SF, SPKCZT SK
WHERE SF.SP_ID=S.SP_ID AND
SF.SP_ID=SK.SP_ID AND
SF.FDBH=SK.FDBH AND
JD.SPCODE=S.SPCODE AND JD.JDSKU IS NOT NULL AND trim(translate(JD.JDSKU,'0123456789',' ')) is NULL AND SF.FDBH=:FDBH
ORDER BY SF.CXLSDJ


以上是原始的查询语句，想查询1000-2000条之间的记录，而且不显示rownum

[aoyousihai]

创建一个带rownum的临时表，将查询数据都插入;然后再从临时表获得想要的数据