bitscn.com
mysql limit子查询语句
（1）mysql limit 不支持子查询像下面这条语句无法执行
select * from b_c_s1 where ct_id in
(select distinct ct_id from b_c_s1 limit 0,2);
（2）应该在只查询外面再加一个查询
select * from b_c_s1 where ct_id in (select a.ct_id from
(select distinct ct_id from b_c_s1 limit 0,2) a)
bitscn.com