这两个怎么才能结合到一起呢? select 種目番号,種目名,sum(件数) as 件数 from flawcodecount_year('${p_role}','${p_kashisha_code}','${p_dairiten}','${p_dairiten_grp}','${p_year}','${p_month_1}','${p_year}','${p_month_2}') where 種目番号 like '0%' or 種目番号 like '1%' group by 種目番号 ,種目名 order by 件数 desc,種目番号 limit 4 select * from flawcodecount_year('${p_role}','${p_kashisha_code}','${p_dairiten}','${p_dairiten_grp}','${p_year}','${p_month_1}','${p_year}','${p_month_2}'); |