oracle group by order by

Question

I have wrote query like:

select name,age from people group by name order by age DESC ;

I want to select max age for same names .but it gives "ORA-00979: not a GROUP BY expression".

Help me please.

Thanks.

Answer 1

Try

SELECT name, MAX(age) A FROM poeple GROUP BY name ORDER BY A DESC