RANK - Revision history

http://sqlzoo.net/w/index.php?title=RANK&feed=atom&action=history RANK - Revision history 2013-05-24T23:54:33Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=RANK&diff=1391&oldid=prev Connor at 15:22, 16 July 2012 2012-07-16T15:22:21Z

<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 15:22, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 15:</td> <td colspan="2" class="diff-lineno">Line 15:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class='<del class="diffchange diffchange-inline">qu</del>'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class='<ins class="diffchange diffchange-inline">ht</ins>'></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>In this example we show the ranking, by population of those countries with a population of over 180 million.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In this example we show the ranking, by population of those countries with a population of over 180 million.</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def <ins class="diffchange diffchange-inline">e-oracle e-sqlserver</ins>'></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,population,</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,population,</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       RANK() OVER (ORDER BY population DESC)</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       RANK() OVER (ORDER BY population DESC)</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 23:</td> <td colspan="2" class="diff-lineno">Line 23:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>FROM bbc WHERE population>180000000</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>FROM bbc WHERE population>180000000</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ORDER BY name</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ORDER BY name</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;"></source> </ins></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;"><source lang='sql' class='def'></ins></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> <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;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr> </table>

Connor http://sqlzoo.net/w/index.php?title=RANK&diff=1166&oldid=prev Connor at 10:52, 13 July 2012 2012-07-13T10:52:42Z

<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 10:52, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 19:</td> <td colspan="2" class="diff-lineno">Line 19:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,population,</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,population,</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       RANK() OVER (ORDER BY population DESC) AS r</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       RANK() OVER (ORDER BY population DESC)</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">      </ins>AS r</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>FROM bbc WHERE population>180000000</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>FROM bbc WHERE population>180000000</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ORDER BY name</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ORDER BY name</div></td></tr> </table>

Connor http://sqlzoo.net/w/index.php?title=RANK&diff=1163&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>RANK() OVER (ORDER BY f DESC)</th></tr> <tr><td align='center'>'''Engine'''</td><td align..." 2012-07-13T10:49:56Z

<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>RANK() OVER (ORDER BY f DESC)</th></tr> <tr><td align='center'>'''Engine'''</td><td align..."</p> <p><b>New page</b></p><div><table align='right' border='1'><br /> <caption>Compatibility</caption><br /> <tr><th colspan='3'>RANK() OVER (ORDER BY f DESC)</th></tr><br /> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br /> <tr><td align='left'>ingres</td><td>No</td><td></td></tr><br /> <tr><td align='left'>mysql</td><td>No</td><td></td></tr><br /> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>postgres</td><td>No</td><td></td></tr><br /> <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br /> </table><br /> <h1>RANK</h1><br /> <p>RANK() OVER (ORDER BY f DESC) returns the rank position relative to the expression f. </p><br /> <pre style='width:60ex'><br /> RANK() OVER (ORDER BY f DESC) <br /> </pre><br /> <br /> <div class='qu'><br /> In this example we show the ranking, by population of those countries with a population of over 180 million. <br /> <source lang='sql' class='def'><br /> SELECT name,population,<br /> RANK() OVER (ORDER BY population DESC) AS r<br /> FROM bbc WHERE population>180000000<br /> ORDER BY name<br /> </source><br /> </div><br /> <br /> <p>See also</p></div>

Connor