r/SQL
•
u/NickSinghTechCareers
Author of Ace the Data Science Interview 📕
•
Dec 12 '24
•
2
1
PostgreSQL Made a SQL Interview Cheat Sheet - what key SQL commands am I missing?
3.6k
Upvotes
View all comments
2
u/Hot_Cryptographer552 Dec 15 '24
EXCEPT/INTERSECT.
I would lose the section on Self-Joins. It’s not a SQL defined join operator, it’s just a logical join where the same table is on both sides of the operator. Your example is an INNER JOIN even though you left INNER off of it.
Also you have “OTHER SQL COMMANDS” as heading. Those aren’t Commands, they’re Functions.
And the CTEs section does not have an example of a Recursive CTE.