http://sqlzoo.net/w/index.php?title=Column_name&feed=atom&action=historyColumn name - Revision history2013-06-20T00:33:40ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=Column_name&diff=1070&oldid=prevMarek at 13:16, 12 July 20122012-07-12T13:16:18Z<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:16, 12 July 2012</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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>You should be able to specify a column name.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>You should be able to specify a column name.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang=sql class='tidy'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang=sql class='tidy'<ins class="diffchange diffchange-inline">></source</ins>></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"><source lang=sql class='setup'></ins></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT region, SUM(population) AS x</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT region, SUM(population) AS x</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td></tr>
</table>Marekhttp://sqlzoo.net/w/index.php?title=Column_name&diff=1069&oldid=prevMarek at 13:15, 12 July 20122012-07-12T13:15:43Z<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:15, 12 July 2012</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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>How can I display a column name for an aggregate function?</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>How can I display a column name for an aggregate function?</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td></tr>
<tr><td colspan="2"> </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;"><div class=params>schema:gisq</div></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Where one of the results returned is calculated (for  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Where one of the results returned is calculated (for  </div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 12:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT region, SUM(population) AS x</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'>SELECT region, SUM(population) AS x</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   FROM <del class="diffchange diffchange-inline">cia</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   FROM <ins class="diffchange diffchange-inline">bbc</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>GROUP BY region</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>GROUP BY region</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
</table>Marekhttp://sqlzoo.net/w/index.php?title=Column_name&diff=841&oldid=prevMarek: Created page with "How can I display a column name for an aggregate function? <div class='ht'> <div> Where one of the results returned is calculated (for example with an aggregate) the column n..."2012-07-11T12:08:21Z<p>Created page with "How can I display a column name for an aggregate function? <div class='ht'> <div> Where one of the results returned is calculated (for example with an aggregate) the column n..."</p>
<p><b>New page</b></p><div>How can I display a column name for an aggregate function?<br />
<div class='ht'><br />
<div><br />
Where one of the results returned is calculated (for <br />
example with an aggregate) the column name may be<br />
assigned arbitrarily.<br />
<br />
You should be able to specify a column name.<br />
</div><br />
<source lang=sql class='tidy'><br />
</source><br />
<source lang='sql' class='def'>SELECT region, SUM(population) AS x<br />
FROM cia<br />
GROUP BY region<br />
</source><br />
</div><br />
<br />
{{SELECT Ref}}</div>Marek