Try Group by.. Having clause with MAX() to find out players name who never scored century
SELECT NAME FROM table
GROUP BY NAME
HAVING MAX(SCORE) < 100;
4
solved how to retrieve player names who never scored a century?
Try Group by.. Having clause with MAX() to find out players name who never scored century
SELECT NAME FROM table
GROUP BY NAME
HAVING MAX(SCORE) < 100;
4
solved how to retrieve player names who never scored a century?