sql如何按某一列中元素出现从多到少排名？

[lovery99]

比如我的数据表是：
列1 列2
A 5
B 3
A 7
B 5
A 1
按照列1元素出现次数排名，比如上面A出现了3次，B出现了2次，那么想输出（A,3）（B,2）这种信息，请问应该怎么查询？谢谢

[moonoos123]

select 列1,count(*) from tab1 group by 列1; 我是感觉你需要的不是这么简单，你可以再写的详细点，我理解的是这样～～

[moonoos123]

select 列1,count(*) from tab1 group by 列1 order by count(*) desc; 忘记升序了～～

[CT_LXL]

SELECT '(' || T2.ID || ',' || T2.CNT || ')' COL
  FROM (SELECT T.ID, COUNT(1) CNT
          FROM TB2 T
         GROUP BY T.ID
         ORDER BY COUNT(1) DESC) T2;

[NIan_jun]

with  t as(
select 'a' a ,1 b from dual 
union all 
select 'a',3 from dual 
union all 
select 'a',5 from dual
 union all 
select 'b',1 from dual
 union all 
select 'b',2 from dual 
)
select a,b,count(*)over(partition by a) c from t order by c desc