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

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

Tb_PaintOut：表明

PaintNumber：字段名

PaintOutTime：时间类型字段

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

标签：