且构网

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

如何使用sql查询更新表中的最后N行。

更新时间:2021-10-29 10:06:45

更新表中的最后N行您提供的信息很少。这是我的猜测

You have provided very Little information. Here is my guess
UPDATE TABLE SET .... WHERE ID IN (select TOP N ID from TABLE order by ID DESC)





你必须根据你的标准改变order by子句



you have to change order by clause based on your criteria