且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何选择最后插入的两行

更新时间:2022-12-12 16:38:59

SELECT TOP(2) * FROM [tablename] ORDER BY Id DESC


第二个是


second is

SELECT TOP(5) * FROM [table] ORDER BY salary DESC