I have table :
table blah:
| name | nmb |
+------+-----+
| andy | 10 |
| alice| 5 |
| carol| 9 |
select name,MAX(nmb) from blah;
Not a single-group group function,
How to get output like :
| name | nmb |
+------+-----+
| andy | 10 |
Could anyone guide in the right direction?
Aucun commentaire:
Enregistrer un commentaire