pivot 行转列的使用
select rq as "日期", nvl(s, 0) as "网上银行", nvl(b, 0) as "现金", nvl(c, 0) as "POS机刷卡",nvl(s, 0)+nvl(b, 0)+nvl(c, 0) as "小计"from (select SFJE, SKLXID, to_char(CREATEDTIME, 'yyyy-mm') as rq from T_CBJFPJ)...
原创
2019-01-24 09:49:10 ·
358 阅读 ·
0 评论