RANK

Compatibility

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