我应该使用哪个MySQL查询来获取只重复X次的行?
例如(愚蠢的例子^^):
John likes apples.
Dave likes apples.
Bough likes bananas.
Light likes apples.
Wiky likes bananas.
我希望得到一个查询,返回只被3个人所喜欢的水果(以苹果为例)。
谢谢!
我应该使用哪个MySQL查询来获取只重复X次的行?
例如(愚蠢的例子^^):
John likes apples.
Dave likes apples.
Bough likes bananas.
Light likes apples.
Wiky likes bananas.
我希望得到一个查询,返回只被3个人所喜欢的水果(以苹果为例)。
谢谢!
SELECT fruit_name FROM `table` group by fruit_name having count(fruit_name)>=3;
select address, count(address) as cnt from mailing_list group by address having cnt = $x order by cnt;
如果您正在尝试计算列中每个重复行:
select count(*), column1 from table group by column
select count(*), column1, column2 from table group by column1,column2
编辑:
如果您想获取仅具有X重复的行:
select c, column1 from (select count(*) as c, column1 from table group by column1) where c = X