Sql统计语句求解答:select Convert(varchar(10),datetime,23) as 日期,sum(in) as 收入,sum(out ) as 支出 from (select datetime, money as in, 0 as out from cash union all select datetime, 0 as in, money as out from expend ) as p group by Convert(varchar(10),datetime,23)把两张表合并成一张...
Access数据库做报表,请教SQL语句如何写:答:SELECT 交易类别, Sum(IIf(Month(交易时间)=1,收入,0)) AS 一月, Sum(IIf(Month(交易时间)=2,收入,0)) AS 二月, Sum(IIf(Month(交易时间)=3,收入,0)) AS 三月, Sum(IIf(Month(交易时间)=4,收入,0)) AS 四月, Sum(IIf(Month(交易时间)=5,收入,0)) AS 五月, Sum(IIf(Month(...