1

    select sub_table.num,sub_table.job_id

    from (

    select count(*) as num,t.job_id 

    from dir_irai t group by t.job_id order by num desc

    ) 

    sub_table where sub_table.num>1

    2　　 

    select distinct sub_table.num,t2.job_id,t2.anken_id,t2.job_id

    from (

    select count(*) as num,t.job_id 

    from dir_irai t group by t.job_id order by num desc

    ) 

    sub_table,dir_irai t2 where sub_table.num>1 and sub_table.job_id=t2.job_id order by t2.job_id 

建议继续学习：

1. 改变了对Mysql子查询的看法    (阅读：3737)
2. WebGame行业案例：in子查询group by引发的“血案”    (阅读：2558)