按照时间排序,删除前面的几行,两种写法:
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其实都是一样。
按照时间排序,删除前面的几行,两种写法:
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其实都是一样。