查询表里的最后一条数据？ 没有ID 没有时间 How to do ?
------解决方案--------------------
declare @num as int
select @num = count(*) from authors
set @num = @num - 1
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)
------解决方案--------------------
2005实现：
select top 1 *
from (select *,row=row_number() over( order by id) from sysobjects)ta
order by row desc