Getting the Count In a single Table MySQL

Question

I need to get the Club_ID of all the clubs that have more than one member;

Here is the sql:

CREATE TABLE `Members` ( `ID` INT NOT NULL AUTO_INCREMENT , `Club_ID` INT NULL , `Name` VARCHAR(45) NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Jim'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('2', 'John'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Bill'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('3', 'Stan'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('4', 'David'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Tony'); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('5', 'Oscar');

This should return Only Club_ID =1!

mzedeler · Accepted Answer · 2013-06-03 21:57:27Z

1

 SELECT COUNT(*), Club_ID FROM Members GROUP BY Club_ID HAVING COUNT(*) > 1

answered Jun 3, 2013 at 21:57

mzedeler

4,3994 gold badges30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Jashi · Accepted Answer · 2013-06-03 21:57:48Z

1

select Club_ID from Members group by Club_ID having count(*)>1

answered Jun 3, 2013 at 21:57

David Jashi

4,5091 gold badge23 silver badges26 bronze badges

Comments

juergen d · Accepted Answer · 2013-06-03 21:57:28Z

0

select club_id from members group by club_id having count(distinct id) >= 2

answered Jun 3, 2013 at 21:57

juergen d

205k40 gold badges304 silver badges377 bronze badges

Collectives™ on Stack Overflow

Getting the Count In a single Table MySQL

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related