lundi 25 juillet 2016

Oracle - not single group func

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