在SQLServer中如何读取一张表最末五行数据？

[crazy_bo]

谢谢

[wzy_love_sly]

select top 5 * from table order by id desc

[wgsasd311]

/*一条SQL语句可能实现不了,因为你的问题必须要用到排序,而排序必须要指定按哪一列或哪几列组合或是表达式.*/
select * ,identity(int,1,1) as pxid into #tmp from tb
select top 5 * from #tmp order by pxid desc
drop table #tmp

[-狙击手-]

如果有唯一标识列
如楼上

如果没有
生成中间表select identity(int,1,1) as id * into # from tb
，再select top 5 ... order by id desc

[hui_hui_2007]

前提是必须要有一个惟一标识列。否则没有严谨的实现办法。

[中国风]

2005时用:
selett top 5 *
from
(select *,row=row_number()over(order by ID)
from T)TT
order by row desc

[dawugui]

--1,按ID排序
select top 5 * from tb order by id 
select top 5 * from tb order by id desc

--2不排序,如何从表中用SELECT语句提取最后10条数据
declare @num as int
select @num = count(*) from authors
set @num = @num - 10

declare @sql as varchar(200)
set @sql = 'select * from authors where au_id not in (select top ' + cast(@num as char) + ' au_id from authors)'
exec (@sql)

[fwacky]

select   top   5   *   from   table   order   by   [你要排序的字段]   desc

[JL99000]

老乌龟的方法更有特点
老乌龟你不被关起来了吗，杂的，出来了啊
回去吧

[fqbnet2050]

不错，学习一下

[shirley_yue]

STUDY

[daviszr_1979]

Select top 5 * From Test Where ID Not In Select Top (Select Count(*)-5 From Test) From Test

[wyl918]

呵呵，学习了，给点分吧，呵呵