RANK
Jump to navigation
Jump to search
| 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