我想查询出一表中指定的记录,例如:我想查询第10条到第20条的记录!该如何是好? -------------------------- 那怎么算排序呢??? 比如有一个时间列dtselect top 11 * from (select top 20 * from tablename order by dt desc)A
select top 11 * from (selct top 20 * from 表 order by 主键) order by 主键 desc
--修改一下 select * from (select top 20 from tablename ) t1 where checksum(*) not in (select top 9 checksum(*) from tblename)
改一下coolingpipe(冷箫轻笛)的 select top 11 * from tablename where checksum(*) not in (select top 9 checksum(*) from tblename)
随机的 select top 11 * from (selct top 20 * from tablename order by newid ) order by newid desc
楼上的子查询加表别名~~~select top 11 * from (selct top 20 * from tablename order by newid)A order by newid desc
--------------------------
那怎么算排序呢???
比如有一个时间列dtselect top 11 * from (select top 20 * from tablename order by dt desc)A
from (selct top 20 * from 表 order by 主键)
order by 主键 desc
select * from
(select top 20 from tablename ) t1
where checksum(*) not in
(select top 9 checksum(*) from tblename)
select top 11 * from tablename where checksum(*) not in
(select top 9 checksum(*) from tblename)
select top 11 *
from (selct top 20 * from tablename order by newid )
order by newid desc
from (selct top 20 * from tablename order by newid)A
order by newid desc