sql按时间删除指定条数数据

mysql：

delete from x_source where id in 
 (select id from x_source order by create_time limit 0,2) ;

如果版本不支持 LIMIT 子句的 IN/ALL/ANY/SOME 子查询

那么加一层就行

delete from x_source where id  in 
 (select t.id from (select id from x_source order by create_time limit 0,2)as t) ;

sqlserver  用top x

delete from x_source where id  in 
 (select top 2 id from x_source order by create_time) ;