Re: [SQL] aggregate question

[Tomasz Myrta]

Dnia 2003-06-24 00:04, Użytkownik Tomasz Myrta napisał:


select package_name,
 count(*) as n_packages
from
 packages
 join package_log using (package_id);

And one more:
select package_name,
 sum(case when package_log.package_id is not null then 1 else 0 end)
   as n_packages
from
 packages
 left join package_log using (package_id);
Add "group by package_name" to these queries...
Tomasz
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster