Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL-statement
One other way:
SELECT
a.id,
a.name,
COUNT(CASE WHEN b.active = 1 THEN 1 ELSE NULL END) active,
COUNT(CASE WHEN b.active = 0 THEN 1 ELSE NULL END) not_active
FROM
company a,
employee b
WHERE a.id = b.compid (+)
GROUP BY
a.id,
a.name
Received on Thu Apr 21 2005 - 18:53:53 CDT