本文共 307 字,大约阅读时间需要 1 分钟。
SELECT * FROM dt20181014 where aa = 'MO-CORE';
to flay,带神奇格式的sql查询模板,需要在编辑状态下复制使用
合并表格并求和
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') ddGROUP BY b;转载于:https://blog.51cto.com/406647516/2308459