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 -> Re: 2 count in a same select

Re: 2 count in a same select

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 29 Apr 2002 16:10:38 GMT
Message-ID: <3CCD707A.8C0E6182@exesolutions.com> 





Look at GROUP BY ... not DISTINCT.



Daniel Morgan





gil guerillot wrote:



> 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 - 11:10:38 CDT












Original text of this message













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