急! ! ! ! 急! ! ! ! 急! ! ! ! 提取表中头10条,头11-20,21-30条,31-40条数据按id降序

[zhirui]

提取表中头10条,头11-20,21-30条,31-40条数据按id降序

[MicrosoftSQL]

有没有主键？

[点点星灯]

--头10条
select top 10 * from tablename order by id desc

--头11-20
select top 10 * from (select top 20 * from tablename order by id)order by id desc

--21-30条
select top 10 * from (select top 30 * from tablename order by id)order by id desc

--31-40条
select top 10 * from (select top 40 * from tablename order by id)order by id desc

[itblog]

select top 10 * from 表名 order by id desc

select top 10 * from 表名 where id not in(select top 10 from 表名 order by id desc) order by id desc

select top 10 * from 表名 where id not in(select top 20 from 表名 order by id desc) order by id desc

select top 10 * from 表名 where id not in(select top 30 from 表名 order by id desc) order by id desc

[Yang_]

--头10条
select top 10 * from tablename order by id desc

--头11-20
select top 10 * from (select top 20 * from tablename order by id desc)order by id

--21-30条
select top 10 * from (select top 30 * from tablename order by id desc)order by id

--31-40条
select top 10 * from (select top 40 * from tablename order by id desc)order by id

[Yang_]

有错

--头10条
select top 10 * from tablename order by id desc

--头11-20
select top 10 * from (select top 20 * from tablename order by id desc) as t order by id

--21-30条
select top 10 * from (select top 30 * from tablename order by id desc) as t order by id

--31-40条
select top 10 * from (select top 40 * from tablename order by id desc) as t order by id

[fcuandy]

select top 10 * from tb
select top 10 * from tb where id>(select max(id) from (select top 10 id from tb) x)
select top 10 * from tb where id>(select max(id) from (select top 20 id from tb) x)
select top 10 * from tb where id>(select max(id) from (select top 30 id from tb) x)

[xyxfly]

这么多星星说了，接点分 ^_^

[berwos]

顶了

[playwarcraft]

我看还是给个表示列,
select flag=identity(int,1,1).* into #t from T order by id desc
然后
select * from #t where flag between 1 and 10
....

[zjcxc]

-- 如果你用sql 2005就简单了

SELECT *
FROM(
SELECT *,
ROW = ROW_NUMBER() OVER(ORDER BY id DESC)
FROM sysobjects
)A
WHERE row BETWEEN 1 AND 10 -- 这里直接改范围

[lg9706032921]

顶,接分吧,终于失业在家了

[shazi_pig]

USE AdventureWorks;
GO
WITH OrderedOrders AS
(SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader )
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60;