create table t(a int,b varchar2(2));
insert into t values(1,'a');
insert into t values(1,'a');
insert into t values(1,'a');
insert into t values(1,'b');
insert into t values(2,'c');
insert into t values(2,'d');
insert into t values(2,'d');
insert into t values(3,'e');
insert into t values(3,'e');
insert into t values(3,'f');
insert into t values(3,'f');
commit;
求某值出现次数最多的SQL写法
select * from t;
A B
---------- --
1 a
1 a
1 a
1 b
2 c
2 d
2 d
3 e
3 e
3 f
3 f
求一SQL,???部分能显示出现次数最多的列(表的第二列，a出现三次，d出现两次,e和f都出现两次，所以显示a,d,e)，若出现次数一样，则随便选一个
select a,????? from t group by a;
a?????
-------- ------
1
a
2
d
3
e
--这里显示e或者f都可以
|
