查询消息的统计数量
时间:2021-12-15 作者:匿名
select num1 ,num2 ,num3,sum(num1+num2+num3) from ( SELECT (SELECT count(0) FROM com_news) AS num1, ( SELECT count(0) FROM plat_news ) AS num2, ( SELECT count(0) FROM police_news ) AS num3 FROM DUAL ) as total;