Question

sql 一组数据90条 要删除前10条外的所有数据？

sql 一组数据90条 要删除前10条外的所有数据？
求如何写表明msg 时间列msgtime

Answer 1

delete from 表名 where id not in(select top(10) id from 表名)

Answer 2

Delete from msg where ID in (select top 10 ID from msg order by msgtime )

id 是主键