2021
01-27
01-27
Postgresql 动态统计某一列的某一值出现的次数实例
实例解析:selectto_char(log.date,'yyyy-MM-ddHH24')ashour,log.exten,sum(caselog.gradewhen'1'then1else0end)as"1",sum(caselog.gradewhen'2'then1else0end)as"2",sum(caselog.gradewhen'3'then1else0end)as"3",sum(caselog.gradewhen'4'then1else0end)as"4",sum(caselog.gradewhen'5'then1else0end)as"5",log.directionfromiface_satisfaction_investi...
继续阅读 >