RANK

From SQLZOO
Revision as of 10:52, 13 July 2012 by Connor (Talk | contribs)

Jump to: navigation, search
Compatibility
RANK() OVER (ORDER BY f DESC)
EngineOKAlternative
ingresNo
mysqlNo
oracleYes
postgresNo
sqlserverYes

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

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense