Sql server 分组统计样例
摘要：
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select ROW_NUMBER()OVER(ORDER BY 模块分组) as 序号 ,模块分组,count(0)as 总表数, sum(case 导换标志 when 'Y' then 1 els... 阅读全文
posted @ 2009-03-12 21:23 Tommy.net 阅读(794) 评论(0) 推荐(0) 编辑