Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> 2 count in a same select

2 count in a same select

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Mon, 29 Apr 2002 14:36:15 +0100
Message-ID: <aajeof$9ch$1@gotix.reseau.ratp> 





i have 2 tables objects and events:



objects:  code,category


events:   object,code,date



join by events.object=object.code



i want to count by category  the number of events and the number of distinct
objects with the same SQL SELECT query



how can i do?
Received on Mon Apr 29 2002 - 08:36:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US