MIMIC-IV

MIMIC-IV PosgreSql

Datetime Diff

SELECT DATE_PART('hour', dischtime - admittime) FROM mimiciv_hosp.admissions;

COALESCE

SELECT COALESCE(3, 7), COALESCE(null, 8), COALESCE(null, null, null);

ROW_NUMBER

SELECT subject_id,  ROW_NUMBER() OVER (PARTITION BY subject_id ORDER BY intime) AS rn FROM mimiciv_icu.icustays limit 100;