Loading…
59+ curated questions with the same answer shape every time: quick recap, deep dive, pitfalls, and follow-ups. Coverage includes sql select where order, joins inner left right full, aggregations group by having, subqueries and nested selects, and more.
Suggested path
Topics follow a teaching order. Each answer ends with a clear Next question control so you can move forward without hunting the list.
SQL is tested in virtually every software engineering interview regardless of role, and freshers are expected to write correct multi-table queries under time pressure. This module covers SELECT with filtering and ordering, the JOIN family (INNER, LEFT, RIGHT, FULL OUTER — and the mental model for each), GROUP BY with HAVING, subqueries, and the string and date functions that come up in take-home tests. Every topic includes a 'write the query for this scenario' exercise because SQL interviews are almost always hands-on.
Full catalog
Topics are ordered for learning. Within each topic, rows are numbered 1–59 globally so you always know where you are. Collapse topics if you want a lighter view — use Expand all when you need the full list again.
Numbers 1–59 follow the order we recommend — click any row to open the full answer, or use the sticky Next link at the bottom of each page to go Q1 → Q59.