Languages & Frameworks
SQL
4 practice questions. Free questions open a full answer guide; the rest unlock with Pro.
- A query using NOT IN with a subquery suddenly returns zero rows even though you expect matches. What's likely going on, and how would you fix it?
- In SQL, what's the difference between the WHERE clause and the HAVING clause, and when do you need each?Go Pro
- In SQL, what is the difference between an INNER JOIN and a LEFT JOIN, and how would you decide which one to use?Go Pro
- When would you reach for a window function with OVER(PARTITION BY ...) instead of a GROUP BY, and what's the practical difference in the result you get back?Go Pro
Want questions matched to your role? Paste a job title, job description, or CV for a personalized set, or go Pro to unlock the full bank.