[SQL] group by and order by

From: Erwan <erwanpianezza_at_my-deja.com>
Date: 20 Jan 2003 03:20:41 -0800
Message-ID: <ef3d78e5.0301200320.4d50428e_at_posting.google.com>


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

Original text of this message