比如表中有好多数据，小弟我想查最后一条，但是这个表对信息没有编号，小弟我要如何查最后一条的信息呢？

declare @num as intselect @num = count(*) from authorsset @num = @num - 1declare @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)