摘要：
分组统计select COUNT(*) as c,CustomerTelp from Customergroup by CustomerTelp查询结果想查找Num大于1的记录目前就想到两个方法方法1：select * from ( select COUNT(*) as num,CustomerTelp from Customer group by CustomerTelp ) a where num>2方法2：with a as ( select COUNT(*) as num,CustomerTelp from Customer group by CustomerTelp )sel. 阅读全文