[ad_1]
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
[ad_2]
solved how to retrieve player names who never scored a century?
[ad_1]
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
[ad_2]
solved how to retrieve player names who never scored a century?