[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>
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
thanks,
erwan in kemper. Received on Mon Jan 20 2003 - 12:20:41 CET