delete table
where id in
(select top 1 id from table where id in
(select top n id from table ) order by id desc
where id in
(select top 1 id from table where id in
(select top n id from table ) order by id desc
where id in
(select top n id from tablename order by id desc)
楼主慎重使用:
用了标准答案请张贴!谢谢!
Delete from table Where MyID = @TheNumToBeDeleted
Alter tabel drop colum MyId