select top 21 * from (select top 40 * from user desc) a
lz是想实现分页效果吧。SELECT * FROM ( SELECT TOP(20) * FROM ( SELECT TOP (20) * FROM table ORDER BY aa DESC ) ORDER BY aa ASC ) ORDER BY aa DESC 试试,我以前在ACCESS里边分页就是这样分的。
不好意思上边写错了一个地反 SELECT * FROM ( SELECT TOP(20) * FROM ( SELECT TOP (40) * FROM table ORDER BY aa DESC ) ORDER BY aa ASC ) ORDER BY aa DESC 在查询中是40才对。呵呵
select top 2 * from 表 where prod_id > (select max(prod_id) from (select top 2 * from 表) as a )
select top 21 * from 结果集 where id not in ( select top 20 id from 结果集)
(
SELECT TOP(20) * FROM
(
SELECT TOP (20) *
FROM table
ORDER BY aa DESC
)
ORDER BY aa ASC
)
ORDER BY aa DESC 试试,我以前在ACCESS里边分页就是这样分的。
SELECT * FROM
(
SELECT TOP(20) * FROM
(
SELECT TOP (40) *
FROM table
ORDER BY aa DESC
)
ORDER BY aa ASC
)
ORDER BY aa DESC
在查询中是40才对。呵呵
select top 21 * from 结果集
where id not in (
select top 20 id from 结果集)
Oracle中用rownum>21 order by XX
用之前先判断一下你的数据的总数。不要超过了。