81. Rank vs Dense Rank

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, weight, RANK() OVER(ORDER BY weight DESC) as rk, DENSE_RANK() OVER(ORDER BY weight DESC) as dr 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.