SQL删除一个表的前几行(如删除日记记录)

delete ad from ad AS a ,(select top 1 id from ad) AS b where a.id =b.id

ad 为表名  id 为表ad里面的字段.
原文地址:https://www.cnblogs.com/xiaobaigang/p/896134.html