80. Row Number by Height

Medium Window Functions

Click a table's header to toggle expand/collapse.

patients

10 cols

patient_id

INTEGER

first_name

VARCHAR(30)

last_name

VARCHAR(30)

gender

CHAR(1)

birth_date

DATE

city

VARCHAR(30)

province_id

CHAR(2)

allergies

VARCHAR(80)

height

DECIMAL(3,0)

weight

DECIMAL(4,0)

doctors

4 cols

admissions

7 cols

province_names

2 cols

Expected SQL

SELECT first_name, height, ROW_NUMBER() OVER(ORDER BY height DESC) as rnk FROM patients;

SQL Editor

Ctrl+Enter to run

Console Output

Write your query and click "Run Query" (Ctrl + Enter) to see results and testcase validation.