本文共 747 字，大约阅读时间需要 2 分钟。

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

)

转载地址：http://lihai.baihongyu.com/