如何从一个sqlserver表里，取最后的5条记录

[csdn3ks]

该表没有顺序号，也没有可排序的字段。
从顶上取 是 select a top 5 from aaa

如何从一个sqlserver表里，取最后的5条记录呢？

[zclxyh]

使用临时表。
select *,IDENTITY(int, 1,1) ID into #temp from 表名

select top 5 * from #temp order by id desc

[yun198183]

学习

[dlkfth]

select * ,IDENTITY(int, 1,1) AS ID
into #temp from chkdb

select top 5 * from #temp order by id desc

[CrazyFor]

select * ,IDENTITY(int, 1,1) AS ID
into #temp from chkdb

select * from (select top 5 * from #temp order by id desc)tem order by id

[zjcxc]

那就只好用临时表

select id=identity(int,1,1),* into #tb from 你的表
delect top 5 * from #tb order by id desc
drop table #tb

[pengdali]

declare @a int,@b varchar(8000)
select @a=count(*)-5 from aaa
set @b='select * from where 主键 not in (select top '+cast(@a as varchar(10))+' 主键 from 表)'

exec(@b)

[txlicenhe]

Select identity(int,1,1) as id,* into #tmp from aaa
select top 5 * from #tmp order by id desc
drop table #tmp

[pengdali]

或：


select *,IDENTITY(int, 1,1) ID into #temp from 表

select top 5 * from #temp order by a desc

[caiyunxia]

select top 5 * from table order by pk desc

[chuxin1]

Gz

[ysycrazy]

使用临时表：
select identity(int,1,1) as ID,* into ＃tb_temp from aaa
select top 5 * from ＃tb_temp order by id desc

[FranklinBHU]

学习ing，做个记号