27,582
社区成员




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)