2012年4月7日
一个简单的 分组 计算组内记录数占比的 语句
摘要： select b as 标识,COUNT(*) AS 数量,(select COUNT(*) from num) as 总数量,(ltrim(cast(count(*)*100./nullif((select count(*) from num),0) as decimal(12,2)))+'%') as 占比 from num group by b order by 数量 阅读全文
posted @ 2012-04-07 15:34 忙碌在路上 阅读(982) 评论(0) 推荐(0) 编辑