sql delete怎么删除表中的最后一条
发布网友
共4个回答
热心网友
sql delete删除表中的最后一条语句为：
delete from table_Name where Id like (select top 1 Id from table_Name order by Id desc)
思路为：查找倒序的第一个，即上面代码中的子sql语句select top 1 Id from table_Name order by Id desc
热心网友
delete from table_Name where Id like (select top 1 Id from table_Name order by Id desc) 查找倒序的第一个，再删除就OK。
热心网友
delete from table_Name where Id like (select top 1 Id from table_Name order by Id desc)
热心网友
删除主键最大的
