MSSQL - 根据时间倒序删除第一行数据 

delete top(1) from Tb_PaintOut where PaintNumber = (select top (1)  PaintNumber from Tb_PaintOut order by PaintOutTime desc)

 

Tb_PaintOut：表明

PaintNumber：字段名

PaintOutTime：时间类型字段

posted on 2015-06-23 13:47  ultrastrong  阅读(861)  评论(0)  编辑  收藏  举报