请教怎么样选择最末一条记录?
怎么样选择最末一条记录?

------解决方案--------------------
有ID吗?

select top 1 * from tb order by id desc
------解决方案--------------------
如果没有任何排序.

declare @num as int
select @num = count(*) from authors
set @num = @num - 1 --这里的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)