Talentd
SQL Interview Kit · 2026 edition · PDF

Walk into your SQL round already knowing the answers.

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.

Questions1,015
A4 pages1,106
Scenarios to write520
Theory to answer495

Built for SQL rounds at TCS NQTInfosysWiproAccentureCognizantAmazonFlipkart and more

You know SELECT and JOIN. The round isn't about that.

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.

Not just the answer. The reason you'd get it wrong.

One of the 520 scenarios, exactly as printed in the book.

Chapter 5 · Q.52EasyTypical in tests at Infosys, Wipro
1 · The question, the way it's asked

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.

2 · A query that runs
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;
3 · The real output
rep_namerevenue_inrrevenue_rank
Aditya Joshi520000.001
Neha Gupta480000.002
Pooja Patel480000.002
Ravi Shankar480000.002
Siddharth Rao310000.005
4 · Common mistakeExpecting RANK() to return 1, 2, 2, 2, 3. RANK() skips numbers after ties. After three reps share rank 2, the next rank is 5, not 3.
5 · Key insightRANK() leaves gaps after ties. If three people tie at rank 2, the next person gets rank 5. This matches how sports rankings work.

Look inside

Real pages from the book.

Every topic an SQL round touches

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.

  1. 01SQL Foundations116 Qs
  2. 02Joins & Relationships116 Qs
  3. 03Aggregations & Grouping107 Qs
  4. 04Subqueries & CTEs106 Qs
  5. 05Window Functions111 Qs
  6. 06DDL & Constraints95 Qs
  7. 07Functions, Procedures & Triggers99 Qs
  8. 08Transactions & Concurrency85 Qs
  9. 09Database Design & Normalization85 Qs
  10. 10Indexing & Query Optimization95 Qs
  11. 11Plus Chapter 11 on the interview itself: how to talk through a query, and the 10 patterns behind most questions.

The 14-day plan

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.

Day 1
SQL basics: theoryCh 1, Q.1-55
Day 2
SQL basics: scenariosCh 1, Q.56-116
Day 3
Joins: theoryCh 2, Q.1-55
Day 4
Joins: scenariosCh 2, Q.56-116
Day 8
Window functions: theoryCh 5, Q.1-50
…
through Day 14: the 50 must-practice questions, timed.

Everything you get

Crack SQL Interviews 2026

1,015 questions over 1,106 A4 pages, with clickable contents

SQL Cheatsheet (bonus PDF)

7 pages to keep open while you practise: query order, joins, windows, NULL rules, five-database table

14-day and 30-day study plans

Every day mapped to a chapter and a question range

Interview Classics

Nth highest salary, deleting duplicates, consecutive-day streaks, calendar gaps, NULL traps

Company index

Questions grouped by the 65 companies whose tests they’re typical of, with page numbers

35 practice tables and the script

Load them on MySQL, PostgreSQL or SQLite and check your own answers against the book

Every future edition

New questions and fixes, added to My Purchases at no cost

Free question lists and this kit

Use them too. But most lists give you a question and an answer someone typed once. Here's the difference.

FeatureTypical free listThis 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–

Questions

How do I get the PDFs after paying?

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.

Can I download it again later?

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.

Can I get a refund?

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.

Which database does it use?

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.

I'm not a fresher. Is it still worth it?

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.

Will these exact questions come up in my interview?

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.

I've never written SQL. Can I start here?

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.

Can I share my copy?

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.

Is it a one-time payment?

Yes. You pay once, by UPI, card or net banking. No subscription and no auto-renewal.

Can I read it on my phone?

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.

Why does the kit mention InterviewKits?

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.

The SQL round is one hour. Be the one who's seen it before.Still building the basics? The roadmaps and FleetCode are free. The kit is for when the round is on the calendar.

₹349₹1,749 · 80% off

1,015 questions · instant PDF