select 列1,count(*) from tab1 group by 列1 order by count(*) desc;忘记升序了~~
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;
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
FROM (SELECT T.ID, COUNT(1) CNT
FROM TB2 T
GROUP BY T.ID
ORDER BY COUNT(1) DESC) T2;
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