Shulou(Shulou.com)06/02 Report--

SELECT * FROM dt20181014 where MO-CORE' aa = 'MO-CORE'

To flay, a sql query template with magical format, needs to be copied and used in editing.

Merge tables and sum

SELECT aa,sum (Count) b

FROM

(SELECT "aa,Count FROM dt20181014 where" aa = 'MO-CORE'

UNION ALL

SELECT 'aaaa, count FROM dt20181015 where' aaaa = 'MO-CORE'

) dd

GROUP BY b

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.