Skip to main content
All Problems
easy0% acceptance

Distinct Diagnoses

The medical records department needs a clean list of every unique diagnosis that has been recorded. Return all distinct diagnosis values from the visits table, sorted alphabetically.

Schema

🔑idINT
🔗patient_idINT
🔗doctor_idINT
visit_dateTEXT
diagnosisTEXT
notesTEXTNULL
follow_up_dateTEXTNULL
statusTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute