Reported in a candidate post, Jan 2022
Various SQL queries and clause execution order
Filed under Credit Suisse
The question
Answer SQL questions covering unique and duplicate records, union vs union all attribute counts, distinct counts, HAVING clause usage, group by, joins, and the order of clause execution.
No write-up yet. Related questions below have one.
Related Credit Suisse questions
Collected from public candidate posts and coding forums. Updated Nov 2026.