Counting comments

[Christopher Hicks]

On Sat, 16 Oct 2004, Gervase Markham wrote:
> Is it possible, either via the GUI or directly in SQL, to say:
>
> "Give me a list of all bugs meeting certain criteria, which in addition
> have (exactly 1|more than 1) comment"?
>
> I can do:
>
> SELECT bug_id, count(bug_when) AS bug_count FROM longdescs GROUP BY bug_id;
>
> but then I can't say "AND bug_count > 1" - it doesn't like that.
>
> At a pinch, I could cope with a solution just for one of the two cases,
> as I could do the root query and subtract.

Isn't that what HAVING is for?

-- 
</chris>

"Documentation is like sex: when it is good, it is very, very good;
and when it is bad, it is better than nothing."  -- Dick Brandon