Re: Making Count(*) return zero
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 9 Dec 2009 13:41:11 -0800 (PST)
Message-ID: <9e081b75-9f05-434c-8033-9d17568028a8_at_v25g2000yqk.googlegroups.com>
Date: Wed, 9 Dec 2009 13:41:11 -0800 (PST)
Message-ID: <9e081b75-9f05-434c-8033-9d17568028a8_at_v25g2000yqk.googlegroups.com>
> if userid 1 has no records . it wont be returned in the query
> instead i want it to show zero so
> userid count
> 1 0
> 2 3
> 3 1
> 4 0
Scalar subqueries as already said or left join as follows:
select userid, count(sometable.val)
from users left join sometable
on (users.userid = sometable.val)
group by userid
Gints Plivna
http://www.gplivna.eu
Received on Wed Dec 09 2009 - 22:41:11 CET