17,089
社区成员
发帖
与我相关
我的任务
分享
SELECT
B.*
FROM
TABLE_B B
INNER JOIN
(
SELECT B.UNIQUEKEY
FROM
(
SELECT B.UNIQUEKEY
FROM TABLE_B B
WHERE 。。。
ORDER BY TABLE_B.NAME, TABLE_B.AGE, TABLE_B.CODE
) B
WHERE ROWNUM<5001
) A ON A.UNIQUEKEY =B.UNIQUEKEY
SELECT B.UNIQUEKEY
FROM
(
SELECT B.UNIQUEKEY
FROM TABLE_B B
WHERE 。。。
ORDER BY TABLE_B.NAME, TABLE_B.AGE, TABLE_B.CODE
) B
WHERE ROWNUM<5001
select t.*, x.*
from (select rownum rn, tt.*
from (select ttt.* from ttt order by pk desc) tt
where rownum <= 5000) t
inner join x on t.col1 = x.col1
order by t.rn
-- where t.rn > 4000
SELECT
B.*
FROM
TABLE_B B
INNER JOIN
(
SELECT B.UNIQUEKEY
FROM
(
SELECT B.UNIQUEKEY
FROM TABLE_B B
WHERE 。。。
ORDER BY TABLE_B.NAME, TABLE_B.AGE, TABLE_B.CODE
) B
WHERE ROWNUM<5001
) A ON A.UNIQUEKEY =B.UNIQUEKEY
ORDER BY TABLE_B.NAME, TABLE_B.AGE, TABLE_B.CODE