一条简单sql语句,按排序删除

xiaoxiao2021-02-28  74

按照时间排序,删除前面的几行,两种写法:

1、

delete from t from (select top(10)* from table1 order by time desc) as t

2、 delete  t  from (select top(10) * from table1 order by time desc ) as t

写法不一样,t其实都是一样。

转载请注明原文地址: https://www.6miu.com/read-72419.html

最新回复(0)