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;
select num1 ,num2 ,num3,sum(num1+num2+num3) from ( SELECT (S…
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;