Reported in a candidate post, Jun 2025
Primary vs foreign key and UNION vs UNION ALL
Filed under Capgemini
The question
Basics of SQL: the difference between primary and foreign key, and between UNION and UNION ALL.
No write-up yet. Related questions below have one.
Related Capgemini questions
Collected from public candidate posts and coding forums. Updated Nov 2026.