1,015 interview questions, each with a query that runs, the real output, and the mistake that costs people the round. Built around the SQL asked in service and product-company rounds, for freshers and experienced engineers alike.
Built for SQL rounds at TCS NQTInfosysWiproAccentureCognizantAmazonFlipkart and more
SQL rounds are lost on the follow-up: the tie, the NULL, the duplicate, the “now do it for every department”. These are the moments the kit drills, question after question.
“Top 3 per department, ties included.”
Most people reach for LIMIT 3. The round wants DENSE_RANK in a subquery, and knows the difference from RANK.
“Why didn’t this return the rows with no manager?”
NULL never equals anything, not even NULL. NOT IN with a NULL in the list quietly returns nothing.
“Find the second highest salary. Now the Nth.”
The follow-up is the real question. The book does it three ways and says when each one breaks.
“What happens if two people book the last seat at once?”
Transactions, isolation levels and locking: the questions that separate a fresher answer from a hire.
One of the 520 scenarios, exactly as printed in the book.
The sales manager at a consumer electronics company in Mumbai needs to rank reps by revenue for January 2026. Three reps hit the exact same number that month, and the manager wants the ranking to reflect that tie honestly, with a gap after it.
SELECT
rep_name,
revenue_inr,
RANK() OVER (ORDER BY revenue_inr DESC) AS revenue_rank
FROM sales_performance sp
JOIN sales_team st ON sp.rep_id = st.rep_id
WHERE quarter = '2026Q1'
AND month = '2026-01'
ORDER BY revenue_rank, rep_name;| rep_name | revenue_inr | revenue_rank |
|---|---|---|
| Aditya Joshi | 520000.00 | 1 |
| Neha Gupta | 480000.00 | 2 |
| Pooja Patel | 480000.00 | 2 |
| Ravi Shankar | 480000.00 | 2 |
| Siddharth Rao | 310000.00 | 5 |
Real pages from the book.




495 theory questions to answer out loud and 520 scenarios to write. Start easy; finish where product companies and experienced-hire rounds spend their time.
The 14-day crash plan tells you exactly what to do each day: two to three hours, one chapter section, a clear target. Got a month? The 30-day plan goes deeper. Less than a week? Chapter 0 lists the six sections to do first.
1,015 questions over 1,106 A4 pages, with clickable contents
7 pages to keep open while you practise: query order, joins, windows, NULL rules, five-database table
Every day mapped to a chapter and a question range
Nth highest salary, deleting duplicates, consecutive-day streaks, calendar gaps, NULL traps
Questions grouped by the 65 companies whose tests they’re typical of, with page numbers
Load them on MySQL, PostgreSQL or SQLite and check your own answers against the book
New questions and fixes, added to My Purchases at no cost
Use them too. But most lists give you a question and an answer someone typed once. Here's the difference.
| Feature | Typical free list | This kit |
|---|---|---|
| Answers run on real databases, with the output shown | – | |
| Scenarios on business data, not toy tables | – | |
| The common mistake for every scenario | – | |
| Notes for MySQL, PostgreSQL, SQL Server, Oracle and SQLite | – | |
| A day-by-day study plan | – | |
| Organised by topic and difficulty, all in one place | – |
No account needed. Pay with your name, email and phone, and the download buttons for the book and the cheatsheet appear straight away; we email you the same links too. If you have a Talentd account (or create one later with the same email), the kit is also in My Purchases (Store → My Purchases), ready to download any time.
Yes. Your purchase includes lifetime access and every future edition free. With a Talentd account, download any time from My Purchases. Bought without an account? Sign up or log in with the same email (verified) and the kit appears in My Purchases.
Yes, within 30 days. If the kit isn't for you, email support@talentd.in within 30 days of buying with your order number, before you download any file (the book or a bonus), and we refund the full amount to your original payment method. Download access for that order ends when the refund is made.
Standard SQL. Every query was run on MySQL 8.4, PostgreSQL 17 and SQLite, and 842 of the 1,015 questions run unchanged on all three. Where databases differ (dates, upserts, procedures, locking), the answer is in MySQL with dialect notes for PostgreSQL, SQL Server, Oracle and SQLite. SQL Server notes were run on SQL Server 2022; Oracle notes are checked against Oracle's documentation.
Yes. 234 questions are rated hard, and the later chapters cover transactions and isolation levels, database design and normalisation, indexing and query plans, which is where experienced-hire and product-company rounds spend their time.
Nobody can promise that. Each question is tagged with the companies whose tests it is typical of, and the company index groups them, so you can spend your time where it counts.
Learn SELECT, WHERE and JOIN from any free tutorial first; that takes an evening. The book picks up from there and every chapter starts with easy questions.
Licensed to you only. Every page carries your name, email and order number. This copy is for your personal use. Sharing, uploading or reselling it, in full or in part, infringes our copyright under the Copyright Act, 1957. Every copy is traceable to its buyer: we will cancel access for that order and may take legal action.
Yes. You pay once, by UPI, card or net banking. No subscription and no auto-renewal.
Yes. It's an A4 PDF with clickable contents, so it opens on any phone, tablet or laptop. Long queries are easier to read on a bigger screen.
InterviewKits is our site for interview books. For now the kit is sold and supported here on Talentd, so questions about it go to support@talentd.in.
Anything else, write to support@talentd.in.
Licensed to you only. Every page carries your name, email and order number. Sharing or reselling it infringes our copyright and may lead to legal action. Full refund on request within 30 days of purchase if no file has been downloaded.