第一条select substr(lettertype,0,4),count(1) from slj_info where lettersrc=2002 and createtime>='${stime}' and createtime<='${etime}' group by substr(lettertype,0,4) 第二条select substr(lettertype,0,4),count(1) from slj_info where lettersrc=2001 and createtime>='${stime}' and createtime<='${etime}' group by substr(lettertype,0,4) 第三条select substr(lettertype,0,4),count(1) from slj_info where lettersrc=2003 and createtime>='${stime}' and createtime<='${etime}' group by substr(lettertype,0,4) 怎么写成一句话? |