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