摘要： 1select sub_table.num,sub_table.job_idfrom (select count(*) as num,t.job_idfrom dir_irai t group by t.job_id order by num desc)sub_table where sub_table.num>12　　select distinct sub_table.num,t2.job... 阅读全文