Find orphaned child rows

sql

SELECT o.order_id
FROM orders o
LEFT JOIN customers c ON c.customer_id = o.customer_id
WHERE c.customer_id IS NULL;

Explanation

Helps audit referential integrity problems.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Data Quality and Maintenance Queries

Detect repeated values that should be unique.

Open In sheetsqlsame section

Keep one row per key and delete the extras.

Open In sheetsqlsame section

Inspect the execution plan for a SELECT statement.

Speed up frequent equality or range predicates.

Paginate by a stable cursor instead of a large OFFSET.

Run a query and collect timing or actual row information where supported.