← All ebooks
SQLSQL Interview QuestionsCareerKit
- TopicSQL
- LevelBeginner
- Length97 pages
- Inside80 questions
- FormatPDF
SQL Interview Questions
Joins, grouping, subqueries and the query-writing questions asked in service and product companies.
What's inside
- SELECT, WHERE and ORDER BY
- Joins explained with diagrams
- GROUP BY and HAVING
- Subqueries and CTEs
- Indexes and normalisation
- 20 practice queries with answers
Sample from the ebook
What is the difference between WHERE and HAVING?
WHERE filters rows before grouping. HAVING filters groups after GROUP BY, so it can use aggregate functions like COUNT().
₹149Was ₹29950% off
Free sample questions
Read 12 full answers from this ebook for free, and see all 80 questions it covers.
- What does a basic SELECT query do?
- In what order does the database actually run the clauses of a query?
- What is a JOIN, and what types are there?
- How does an INNER JOIN work?