按小时汇总并行转列
按小时汇总并行转列
oracle写法:
SELECT TO_CHAR(WAITBEGIN, 'YYYY-MM-DD') "day",
count(distinct op.CALLID) "count",
count(decode(TO_CHAR(WAITBEGIN, 'HH24'), '00', 1, null)) "00",
count(decode(TO_CHAR(WAITBEGIN, 'HH24'), '0
原创
2020-06-19 13:46:38 ·
156 阅读 ·
0 评论