如果有id 之类的你可以 使用select top 1 * from urtable order by id desc
select top 1 * from table order by desc
declare cursor_Name cursor keyset for select * from 表 order by 1 open cursor_Name fetch last from cursor_Name while fetch_status=0 begin ... end close cursor_Name deallocate cursor_Name
select * from 表
order by 1
open cursor_Name
fetch last from cursor_Name
while fetch_status=0
begin
...
end
close cursor_Name
deallocate cursor_Name