Home -> Usenet -> comp.databases.oracle -> Re: [SQL] group by and order by

Re: [SQL] group by and order by

From: wiggam14 <member22780_at_dbforums.com>
Date: Mon, 20 Jan 2003 12:36:53 +0000
Message-ID: <2411790.1043066213_at_dbforums.com> 








sure, like this....




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 count(ext_log_date);


--
Posted via http://dbforums.com


Received on Mon Jan 20 2003 - 13:36:53 CET












Original text of this message