Talk:Having (SQL)

Combine this with GROUP BY

I think this article and GROUP BY should be combined because HAVING is only used with GROUP BY. --Whiteknox 13:11, 9 October 2006 (UTC)

That's probably a good idea. Oh, and thanks for fixing my typo at GROUP BY. -- CodeNaked 14:42, 9 October 2006 (UTC)

I agree as well.--Jirka6 (talk) 17:14, 14 February 2008 (UTC)

There are plenty of times at least in MySQL when a Having is useful without a Group By such as: Select a + b * c as D From E Having D > 1, Having in MySQL functions such that Select * from a having b = 1 is esentially the same as select * from (select * from a) as c where b = 1 —Preceding unsigned comment added by 66.173.15.10 (talk) 15:44, 10 November 2008 (UTC)

Cite http://dev.mysql.com/doc/refman/5.0/en/group-by-hidden-fields.html

How about an article on aggregating records? Kayau (talk · contribs) 13:36, 25 February 2013 (UTC)

Multiple conditions

I think there should be an example with multiple conditions (are they separated by ands or by commas?) --Jirka6 (talk) 17:14, 14 February 2008 (UTC)