-
优雅的怨妇
发布于 2021-01-26 10:32
-
收藏
实例解析:select to_char(log.date, 'yyyy-MM-dd HH24') as hour,log.exten, sum(case log.grade when '1' then 1 else 0 end) as "1",sum(case log.grade when '2' then 1 else 0 end) as "2",sum(case log.grade when '3' then 1 else 0 end) as..