计算每天 收入，支出，余额

ID(主键), TYPE(1收入 0支出), MONERY(金额), BANKDATE(日期时间)

 

SELECT CONVERT(VARCHAR(10),BANKDATE,120)  AS 日期,

SUM(CASE  TYPE  WHEN 0 THEN MONERY ELSE 0 END ) AS 收入,

SUM(CASE  TYPE  WHEN 1 THEN MONERY ELSE 0 END ) AS 支出,

SUM(CASE  TYPE  WHEN 0 THEN MONERY ELSE 0 END )- SUM(CASE  TYPE  WHEN 1 THEN MONERY ELSE 0 END ) AS 余额

FROM BANKMONERY

GROUP BY CONVERT(VARCHAR(10),BANKDATE,120)  ORDER BY 日期 DESC