Difference between revisions of "RANK"
| Line 15: | Line 15: | ||
</pre> | </pre> | ||
| − | <div class=' | + | <div class='ht'> |
| − | In this example we show the ranking, by population of those countries with a population of over 180 million. | + | In this example we show the ranking, by population of those countries with a population of over 180 million. |
| − | <source lang='sql' class='def'> | + | <source lang='sql' class='def e-oracle e-sqlserver'> |
SELECT name,population, | SELECT name,population, | ||
RANK() OVER (ORDER BY population DESC) | RANK() OVER (ORDER BY population DESC) | ||
| Line 23: | Line 23: | ||
FROM bbc WHERE population>180000000 | FROM bbc WHERE population>180000000 | ||
ORDER BY name | ORDER BY name | ||
| + | </source> | ||
| + | <source lang='sql' class='def'> | ||
</source> | </source> | ||
</div> | </div> | ||
<p>See also</p> | <p>See also</p> | ||
Revision as of 15:22, 16 July 2012
| RANK() OVER (ORDER BY f DESC) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | |
| mysql | No | |
| oracle | Yes | |
| postgres | No | |
| sqlserver | Yes | |
RANK
RANK() OVER (ORDER BY f DESC) returns the rank position relative to the expression f.
RANK() OVER (ORDER BY f DESC)
In this example we show the ranking, by population of those countries with a population of over 180 million.
SELECT name,population,
RANK() OVER (ORDER BY population DESC)
AS r
FROM bbc WHERE population>180000000
ORDER BY name
See also
