http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&feed=atom&action=history 2013-05-20T00:33:23Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=13159&oldid=prev 2013-05-07T21:30:06Z

<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 21:30, 7 May 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td></tr> </table>

Andr3w http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=13158&oldid=prev 2013-05-07T10:51:54Z

<p>fixed name in table - from &#039;asia&#039; to &#039;Asia&#039;</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 10:51, 7 May 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 10:</td> <td colspan="2" class="diff-lineno">Line 10:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;<del class="diffchange diffchange-inline">asia</del>&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;<ins class="diffchange diffchange-inline">Asia</ins>&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;<del class="diffchange diffchange-inline">asia</del>&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;<ins class="diffchange diffchange-inline">Asia</ins>&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> </table>

95.108.174.97 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=9984&oldid=prev 2013-03-16T13:06:59Z

<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:06, 16 March 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2019&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;<del class="diffchange diffchange-inline">indonesia</del>&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;<ins class="diffchange diffchange-inline">india</ins>&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> </table>

49.206.12.90 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=9983&oldid=prev 2013-03-16T13:05:15Z

<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:05, 16 March 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2004&lt;/td&gt;&lt;td align='left'&gt;Athens&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2004&lt;/td&gt;&lt;td align='left'&gt;Athens&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;td align='left'&gt;Asia&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;<del class="diffchange diffchange-inline">2012</del>&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td&gt;<ins class="diffchange diffchange-inline">2019</ins>&lt;/td&gt;&lt;td align='left'&gt;London<ins class="diffchange diffchange-inline">&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</ins></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 class="diffchange diffchange-inline">&lt;tr&gt;&lt;td&gt;2016&lt;/td&gt;&lt;td align='left'&gt;india&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</ins></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 class="diffchange diffchange-inline">&lt;tr&gt;&lt;td&gt;2018&lt;/td&gt;&lt;td align='left'&gt;indonesia&lt;/td&gt;&lt;td align='left'&gt;asia&lt;/td&gt;&lt;/tr&gt;</ins></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 class="diffchange diffchange-inline">&lt;tr&gt;&lt;td&gt;2014&lt;/td&gt;&lt;td align='left'&gt;england</ins>&lt;/td&gt;&lt;td align='left'&gt;Europe&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td></tr> </table>

49.206.12.90 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=9226&oldid=prev 2013-03-01T01:12:37Z

<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 01:12, 1 March 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&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;">&lt;div class='params'&gt;schema:scott&lt;/div&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='setup'&gt; CREATE TABLE games(</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='setup'&gt; CREATE TABLE games(</div></td></tr> </table>

Andr3w http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=9225&oldid=prev 2013-03-01T01:08:39Z

<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 01:08, 1 March 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;div class='ht'&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">&lt;div class=params&gt;schema:scott&lt;/div&gt;</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='setup'&gt; CREATE TABLE games(</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang=sql class='setup'&gt; CREATE TABLE games(</div></td></tr> </table>

Andr3w http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=7917&oldid=prev 2013-01-22T18:00:28Z

<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 18:00, 22 January 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SELECT .. GROUP BY&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SELECT .. GROUP BY&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Host cities and continents for the Olympics Games are stored in the table &lt;code&gt;<del class="diffchange diffchange-inline">scott.</del>games&lt;/code&gt;.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Host cities and continents for the Olympics Games are stored in the table &lt;code&gt;games&lt;/code&gt;.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Notice that Europe appears in the table twice: &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Notice that Europe appears in the table twice: &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;table&gt;</div></td></tr> </table>

15.211.201.82 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=7916&oldid=prev 2013-01-22T17:58:59Z

<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 17:58, 22 January 2013</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SELECT .. GROUP BY&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;SELECT .. GROUP BY&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Host cities and continents for the Olympics Games are stored in the table &lt;code&gt;games&lt;/code&gt;.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Host cities and continents for the Olympics Games are stored in the table &lt;code&gt;<ins class="diffchange diffchange-inline">scott.</ins>games&lt;/code&gt;.</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Notice that Europe appears in the table twice: &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>Notice that Europe appears in the table twice: &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;table&gt;</div></td></tr> </table>

15.211.201.82 http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=6219&oldid=prev 2012-12-29T04:16:36Z

<p>Undo revision 5917 by <a href="/wiki/Special:Contributions/78.56.155.61" title="Special:Contributions/78.56.155.61">78.56.155.61</a> (<a href="/w/index.php?title=User_talk:78.56.155.61&amp;action=edit&amp;redlink=1" class="new" title="User talk:78.56.155.61 (page does not exist)">talk</a>)</p> <a href="http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&amp;diff=6219&amp;oldid=5917">Show changes</a>

JesseTG http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&diff=5917&oldid=prev 2012-12-24T11:58:43Z

<p></p> <a href="http://sqlzoo.net/w/index.php?title=SELECT_.._GROUP_BY&amp;diff=5917&amp;oldid=1421">Show changes</a>

78.56.155.61