Find Duplicate Patients (NULL-Safe, is not distinct) - PostgreSQL #71

Postgres Engine

Database Schema

Question (#71)

Write a query to find patients who share the same first_name, last_name and birth_date. Each duplicate found should be shown once.

Expected Output

Execute a query or press Ctrl+Enter to view results...

Databases & Questions

Hint

Equality with NULL never matches, so think about a NULL-safe comparison.

Official Solutions

Select a solution...