I want to do Order by before Group by ?

[larius]

Hi,

I would like to make a select request...

my table:

name | coef
|
Julie | 21
Marc | 35
Julie | 18
Julie | 1
Didier | 5
Marc | 11

I would (Distinct Name) and sort max(coerf)

Marc | 35
Julie | 21
Didier | 5

I try

select name, coef from table group by name sort by coef

but Group by make before sort by. Do you have an astuce for a pretty french girl ???

Kiss.