Question

sql server 2000 怎么显示表中最后一行数据

sql server 2000 怎么显示表中最后一行数据
急啊！

Answer 1

1。如果有主键：
select top1 * from table order by 主键 desc
2。如没有主键:

select identity(int,1,1)asrowid,* into # from table

select top1 * from # order by rowid desc

Answer 2

用倒序排列就OK
select top 1 from 表名 order by 排序列名称 desc
desc 倒序排列 asc升序 也是默认的

Answer 3

select top 1 *
from 表
order by 你要排序的字段 desc

Answer 4

select top 1 * from 表 order by id desc

Answer 5

我来给一个真正可行的答案,不用倒序，也不用理会主键：

假设要查询的表是“T1”，那么：

select identity(int,1,1) as 'row',T1.* into #t_temp from T1;
select * from #t_pppp where row =(select count(*) from T1);
drop table #t_temp;

给分吧！

Answer 6

倒序，再用TOP 1取不就行了？