Andr3w at 13:20, 9 August 2012

2012-08-09T13:20:17Z

Marek at 11:30, 19 July 2012

2012-07-19T11:30:08Z

Marek: Created page with "

schema:gisq

ORA-00934: group function is not allowed here

Error 1111 I..."

2012-07-19T11:20:52Z

Created page with "<div class='err'> <div class=params>schema:gisq</div> <div class = "link e-oracle">ORA-00934: group function is not allowed here</div> <div class = "link e-mysql">Error 1111 I..."

New page

<div class='err'>
<div class=params>schema:gisq</div>
<div class = "link e-oracle">ORA-00934: group function is not allowed here</div>
<div class = "link e-mysql">Error 1111
Invalid use of group function</div>
<div class = "link e-sqlserver">Msg 147 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference. </div>
<div class = "link e-postgres">ERROR: Aggregates not allowed in WHERE clause</div>
<div class = "link e-db2">SQL0120N A WHERE clause, GROUP BY clause, SET clause, or SET transition-variable statement contains a column function.</div>
<div class = "link e-sqlserver>Msg 1013,
Ambiguous column name 'name'.</div>

<div>
<h2>Problem</h2><p>
We want to filter the results returned based on an <i>aggregate</i>
function such as COUNT or SUM.
</p><p>
The WHERE clause may not be used for this. The WHERE conditions are
considered before the aggregation.
</p><h2>Solutions</h2><ul><li>Put the condition into the HAVING clause, after the GROUP BY
clause.</li><pre>SELECT winner FROM nobel
GROUP BY winner
HAVING COUNT(winner)>1
</pre></ul>
</div>

<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def'>SELECT winner FROM nobel
WHERE COUNT(winner)>1
GROUP BY winner
</source>

<div class="ecomm e-mysql" style="display: none">In MySQL on LINUX the table names are case sensitive. This means that
the table <code>bbc</code> exists but <code>Bbc</code> gives an error.
This is a deviation from the SQL standard.
</div>
</div>

← Older revision		Revision as of 13:20, 9 August 2012
Line 37:		Line 37:
	</div>		</div>
	</div>		</div>
		+	[[Category:Error]]

@@ Line 7: / Line 7: @@
 <div class = "link e-postgres">ERROR: Aggregates not allowed in WHERE clause</div>
 <div class = "link e-db2">SQL0120N A WHERE clause, GROUP BY clause, SET clause, or SET transition-variable statement contains a column function.</div>
-<div class = "link e-sqlserver>Msg 1013,
+<div class = "link e-sqlserver">Msg 1013,
 Ambiguous column name 'name'.</div>

Invalid Group function - Revision history

Andr3w at 13:20, 9 August 2012

Marek at 11:30, 19 July 2012

Marek: Created page with " schema:gisq ORA-00934: group function is not allowed here Error 1111 I..."

Marek: Created page with "

schema:gisq

ORA-00934: group function is not allowed here

Error 1111 I..."