Re: SQLServer to Oracle

select
 p.id, p.name, count(*) cnt
from
 parent p, child c
where
 p.id = p.id
group by
 p.id, p.name;

--
Flapper