Re: 2 count in a same select

Try this one:
select category, nvl(sum(cnt_do), 0) cnt_events, decode(sum(cnt_do), null, 0, count(0)) cnt_distinct_objects
from objects o,

        (select code, object, count(0) cnt_do from events group by code, object) e
where o.code = e.code(+)
group by category

Uzytkownik "gil guerillot" <gil.guerillot_at_ratp.fr> napisal w wiadomosci news:aajeof$9ch$1_at_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 Tue Apr 30 2002 - 03:28:23 CDT