select * from exec_activity_effect_day oe where oe.ACTIVITY_ID in (select DISTINCT(e.ACTIVITY_ID) from exec_activity_effect_day e limit 0 ,3)
[SQL] select * from exec_activity_effect_day oe where oe.ACTIVITY_ID in (select DISTINCT(e.ACTIVITY_ID) from exec_activity_effect_day e limit 0 ,3) [Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
低版本中mysql不支持在limit语句中有子查询
所以只要在有limit的语句里再向外包一层
( select t.ACTIVITY_ID from (select DISTINCT(e.ACTIVITY_ID) from exec_activity_effect_day e limit 0 ,3) as t)
把上面的结果作为一个新的t表
再查t表就ok ,整个语句如下
SELECT * FROM exec_activity_effect_day oe WHERE oe.ACTIVITY_ID IN ( SELECT t.ACTIVITY_ID FROM ( SELECT DISTINCT (e.ACTIVITY_ID) FROM exec_activity_effect_day e LIMIT 0, 3 )AS t )