当前位置: 代码迷 >> Sql Server >> 重复次数排序的有关问题
  详细解决方案

重复次数排序的有关问题

热度:48   发布时间:2016-04-24 10:49:40.0
重复次数排序的问题
本帖最后由 ysycysyc 于 2014-05-04 19:44:40 编辑
表MB有三个字段A、B、C,数据如下
A                    B                      C
--------------------------------------------
0                          4                          8
1                          4                          8
1                          4                          8
2                          4                          8
2                          4                          8
2                          5                          8
3                          5                          8
3                          5                          8
3                          5                          9
3                          5                          9
3                          5                          9
3                          9                          9
3                          9                          9
3                          9                          9
想分别求三列中,0-9的重复次数及得复次数的排序,和整个表中0-9的重复次数及得复次数的排序,上面数据中,A列的结果为

值        重复次数              重复次数排序
------------------------------------------
0                          1                          4
1                          2                          3
2                          3                          2
3                          8                          1
  相关解决方案