MySQL count select query with condition

Question

I have a mysql table called Game which has two columns, Name and Score. I want to select only the Names whose scores have been atleast 100 and atleast twice. In the below example Ron and Mary will get selected. I am not sure how to write the select statement for this.

Game table

Giorgos Betsos · Accepted Answer · 2015-12-15 15:58:39Z

3

Use GROUP BY with a HAVING clause:

SELECT Name
FROM mytable
GROUP BY Name
HAVING COUNT(CASE WHEN Score >= 100 THEN 1 END) >= 2

HAVING clause checks for Name groups, having at least two records with Score >= 100.

edited Dec 15, 2015 at 15:58

answered Dec 15, 2015 at 15:57

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

MySQL count select query with condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related