[SQL] group by and order by

Hi, how is it possible to order a group by query on a field that is aggregated ?

I get the famous ORA-00979 error when i run this one :

select ext_profil_id, ext_code, count(ext_log_date) as nb_connect from ext_log, extranet_pro where ext_log.ext_profil_id= extranet_pro.id and ext_action_id=1 group by ext_profil_id, ext_code order by ext_log_date

thanks,

erwan in kemper. Received on Mon Jan 20 2003 - 12:20:41 CET