2012年11月23日
SQl Group by
摘要： 分组统计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. 阅读全文
posted @ 2012-11-23 10:56 yellowshorts 阅读(105) 评论(0) 推荐(0)