Talk:Having (SQL)
Add topicLatest comment: 13 years ago by Kayau in topic Combine this with GROUP BY
 | This article is rated Stub-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||
| ||||||||||||||||||
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
[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)