摘要： 1、 date num2005-01-01 12005-01-01 32005-01-02 5要求用一个SQL查出如下结果2005-01-01 42005-01-02 5合计 9参考sql：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select date, sum(num) as num fromtablegroupby dateunionselec '合计'as date, sum(num) as num fromta 阅读全文