Editing Select (SQL) (section)

=== RANK() window function ===
The <code>RANK() OVER</code> window function acts like ROW_NUMBER, but may return more or less than ''n'' rows in case of tie conditions, e.g. to return the top-10 youngest persons:

<syntaxhighlight lang="sql" highlight="3">
SELECT * FROM (
  SELECT
    RANK() OVER (ORDER BY age ASC) AS ranking,
    person_id,
    person_name,
    age
  FROM person
) AS foo
WHERE ranking <= 10
</syntaxhighlight>

The above code could return more than ten rows, e.g. if there are two people of the same age, it could return eleven rows.