摘要： 1.语法：select t.srtypeid,cnt,s.fullname name from (select srtypeid,count(1) cntfrom kfgl_repeat_process_detail where partition_month='&month' and (partition_id_region ='&region_id' or 10 ='&region_id')group by srtypeidorder by count(1) desc) t,sdt_servicerequesttype 阅读全文