Anda boleh mengira bilangan nilai, mencari nilai yang paling kerap, dan juga menapis berdasarkan bilangan nilai:

select x.* from (select val, count(*) as cnt, row_number() over (order by count(*) desc ) as seqnum, count(*) over () as num_vals count(*) over (partition by count(*)) as cnt_cnt from table group by val ) x where cnt_cnt = 1 and seqnum = 1 and num_vals > 1;

Sebenarnya, anda boleh menggunakanhaving子句和order byuntuk mencapai:

select val from (select val, count(*) as cnt, count(*) over () as num_values from table group by val ) v where num_values > 1 order by cnt desc;