SELECT *
FROM (SELECT ROW_.*, ROWNUM ROWNUM_
FROM (select * from tb_test2) ROW_
WHERE ROWNUM <=10)
WHERE ROWNUM_ >= 1主要是这条比较简单
FROM (SELECT ROW_.*, ROWNUM ROWNUM_
FROM (select * from tb_test2) ROW_
WHERE ROWNUM <=10)
WHERE ROWNUM_ >= 1主要是这条比较简单
SELECT *
FROM (SELECT ROW_.*, ROWNUM ROWNUM_
FROM (select * from tb_test2 order by xxx) ROW_
WHERE ROWNUM <=10)
WHERE ROWNUM_ >= 1
如果不排序可以这样:SELECT ROW_.*,
FROM ( select tb_test2.*, ROWNUM ROWNUM_
from tb_test2
WHERE ROWNUM <=10) ROW_
)
WHERE ROWNUM_ >= 1