2011年3月25日
sql求平均秩序
摘要： SELECT callinamount,AVG(n*1.0)OVER(PARTITION BY r)FROM(SELECT callinamount , (RANK() OVER ( ORDER BY callinamount )) r , (ROW_NUMBER() OVER ( ORDER BY callinamount )) nFROM #t) aORDER BY callinamount 阅读全文
posted @ 2011-03-25 14:24 hesion001 阅读(161) 评论(0) 推荐(0) 编辑