27,579
社区成员
发帖
与我相关
我的任务
分享
if ((select count(*) from my_table)>100)
;with t as
(select top 10 *
from my_table
order by in_time desc)
delete from t;
if (select count(*) from my_table) > 100)
delete
from my_table
where id in
(select top 10 id from my_table order by in_time desc)