1、创建测试表,
create table test_count(id varchar2(20), value varchar2(20));
2、插入测试数据
insert into test_count values(1, 1);
insert into test_count values(2, 1);
insert into test_count values(3, 1);
insert into test_count values(4, 2);
insert into test_count values(6, 1);
insert into test_count values(7, 3);
insert into test_count values(8, 3);
insert into test_count values(9, 3);
insert into test_count values(10, 3);
commit;
3、查询表中全量数据,select t.*, rowid from test_count t;
4、编写sql,可以得到每一个value重复的个数,并按照由大到小排列;
select value, count(*) from test_count t group by value order by 2 desc