http://sqlzoo.net/w/index.php?title=No_Group_By_Function&feed=atom&action=history 2013-05-24T14:10:17Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=No_Group_By_Function&diff=3377&oldid=prev 2012-08-09T13:20:27Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 13:20, 9 August 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 29:</td> <td colspan="2" class="diff-lineno">Line 29:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class=&quot;ecomm e-access&quot; style=&quot;display: none&quot;&gt;&lt;/div&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class=&quot;ecomm e-access&quot; style=&quot;display: none&quot;&gt;&lt;/div&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/div&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/div&gt;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category:Error]]</ins></div></td></tr> </table>

Andr3w http://sqlzoo.net/w/index.php?title=No_Group_By_Function&diff=1889&oldid=prev 2012-07-19T11:52:24Z

<p>Created page with &quot;&lt;div class=&#039;err&#039;&gt; &lt;div class=params&gt;schema:gisq&lt;/div&gt; &lt;div class = &quot;link e-oracle&quot;&gt;ORA-00937: not a single-group group function&lt;/div&gt; &lt;div class = &quot;link e-mysql&quot;&gt;Error 1140 Mi...&quot;</p> <p><b>New page</b></p><div>&lt;div class='err'&gt;<br /> &lt;div class=params&gt;schema:gisq&lt;/div&gt;<br /> &lt;div class = &quot;link e-oracle&quot;&gt;ORA-00937: not a single-group group function&lt;/div&gt;<br /> &lt;div class = &quot;link e-mysql&quot;&gt;Error 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause &lt;/div&gt;<br /> &lt;div class = &quot;link e-sqlite&quot;&gt;ORA-00937: not a single-group group function&lt;/div&gt;<br /> &lt;div class = &quot;link e-postgres&quot;&gt;Error 7 ERROR: Attribute xxx.xxx must be GROUPed or used in an aggregate function&lt;/div&gt;<br /> &lt;div class = &quot;link e-db2&quot;&gt;ORA-00937: not a single-group group function&lt;/div&gt;<br /> &lt;div class = &quot;link e-sqlserver&quot;&gt;ORA-00937: not a single-group group function&lt;/div&gt;<br /> <br /> &lt;div&gt;<br /> &lt;h2&gt;Problem&lt;/h2&gt;<br /> &lt;p&gt;Usually we must have a GROUP BY clause if in aggregate function (such as SUM or COUNT) is used.&lt;/p&gt;<br /> &lt;p&gt;The exception is when only aggregate functions are used on the SELECT clause. If we mix aggregate and non-aggregate values then there must be a GROUP BY clause.&lt;/p&gt;<br /> &lt;h2&gt;Solutions&lt;/h2&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;Remove the offending field from the SELECT line&lt;/li&gt;<br /> &lt;li&gt;Add the field to the GROUP BY clause&lt;/li&gt;<br /> &lt;li&gt;Aggregate the offending field&lt;/li&gt;<br /> &lt;/ul&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;source lang=sql class='tidy'&gt;&lt;/source&gt;<br /> &lt;source lang=sql class='setup'&gt;&lt;/source&gt;<br /> <br /> &lt;source lang='sql' class='def'&gt;SELECT name, MAX(population)<br /> FROM bbc<br /> &lt;/source&gt;<br /> <br /> &lt;div class=&quot;ecomm e-access&quot; style=&quot;display: none&quot;&gt;&lt;/div&gt;<br /> &lt;/div&gt;</div>

Connor