SQL语句：
select t.type, count(t.id) as todo_count from mc_job_form t where t.state = '2' and t.customs_code = :a group by t.typeselect t.type, count(t.id) as todo_count
阅读背景：
SQL优化一例：GROUP BY的语句
来源：互联网
分享到：
