SQL: COUNT(column) is not COUNT(*), and neither is COUNT(DISTINCT)

COUNT(*) counts rows. COUNT(col) counts rows where col is not NULL. After an outer join these differ by exactly the unmatched rows - which is usually the number somebody is about to report to a customer.

Full code & output

This topic is available to PRO members.

Sign in Create a free account

Run this yourself in the Online Java Compiler, spin up a live REST API in the API Sandbox, or practise with Java interview questions.

Published 2026-08-25