在数据库中使用IDENTITY COLUMN。如果没有，请将其添加到现有表中。然后按以下步骤操作：

Use IDENTITY COLUMN in your database. If you don't have one,add it to existing table.Then proceed as follows:

Select TOP 1 * from your_table ORDER BY identity_column DESC

问候..

Regards..

SELECT * FROM(SELECT rownum nbr, t.* FROM dept t order by deptno)

where nbr>(select count(*)-1 from dept)

这里有更多答案

如何在不使用MAX /的情况下获取sql server中的最后一个记录值TOP条款？ [ ^ ]

Here more answers
how to get last record value in sql server without using MAX/TOP clause?[^]