61
SQL Server Interview
Joins, Subqueries, CTEs & Set Operators
SQL Server interview questions covering joins, subqueries, ctes & set operators.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
62
What is an INNER JOIN?
63
What is a LEFT JOIN?
64
What is a RIGHT JOIN?
65
What is a FULL OUTER JOIN?
66
What is a CROSS JOIN?
67
What is a SELF JOIN?
68
What is the difference between conditions in ON and WHERE for an OUTER JOIN?
69
How do you find rows that have no matching related record?
70
What is a subquery?
71
What is a scalar subquery?
72
What is a correlated subquery?
73
What is EXISTS?
74
What is the difference between EXISTS and IN?
75
What is the difference between NOT EXISTS and NOT IN?
76
What is a Common Table Expression (CTE)?
77
What is a recursive CTE?
78
What is UNION?
79
What is the difference between UNION and UNION ALL?
80