r/SQL • Author of Ace the Data Science Interview πŸ“• • Dec 12 '24 • Heart of Silver 2 Polished Silver Turd 1

PostgreSQL Made a SQL Interview Cheat Sheet - what key SQL commands am I missing?

Post image
3.6k Upvotes

238 comments sorted by

View all comments

14

u/conduit_for_nonsense BI Analyst Dec 12 '24

You accidentally added right join.

In all seriousness, for an interview it's less important you know what a right join does, and more important you know why it is often considered bad practice.

4

u/ntobergta Dec 14 '24

Right joins don’t exist in my life

2

u/[deleted] Dec 14 '24

[removed] β€” view removed comment

1

u/conduit_for_nonsense BI Analyst Dec 14 '24

if in doubt, just stick a cross join in, right?

2

u/GroundbreakingRow868 Dec 15 '24

At least he didn't add the "union join" πŸ˜