联合查询 举例:
select (select COUNT(id) from emailcontent where state=1 and hasRead=0) as a,
(select COUNT(id) from emailcontent where state=1 and hasRead=1) as b,
(select COUNT(id) from emailcontent where state=1 and hasRead=2) as c
结果集: [{a=0, b=31, c=0}]
一条select语句实现多条查询语句