create table ta(a int) insert ta select 2 union all select 3 union all select 5 union all select 5 union all select 5 union all select 1 union all select 1 union all select 4 union all select 4 union all select 4 --查询 select a from ta group by a having count(*)>=all(select count(*) from ta group by a ) --清除 drop table ta
insert ta select 2
union all select 3
union all select 5
union all select 5
union all select 5
union all select 1
union all select 1
union all select 4
union all select 4
union all select 4
--查询
select a
from ta
group by a
having count(*)>=all(select count(*) from ta group by a )
--清除
drop table ta
-- filebat(Mark) 楼上的是对的!