Talk:Having (SQL)

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Computing

	This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing
???	This article has not yet received a rating on the project's importance scale.

Databases (inactive)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

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

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]

Combine this with GROUP BY

Multiple conditions

Combine this with `GROUP BY`