Jump to content

Talk:Having (SQL)

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

Combine this with GROUP BY

[edit]

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)[reply]

That's probably a good idea. Oh, and thanks for fixing my typo at GROUP BY. -- CodeNaked 14:42, 9 October 2006 (UTC)[reply]
I agree as well.--Jirka6 (talk) 17:14, 14 February 2008 (UTC)[reply]
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)[reply]
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)[reply]

Multiple conditions

[edit]
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)[reply]