Collections Articles Snippets Quizzes

Codevity — learn to code, one question at a time.

SQL Interview Quiz: Logic, Subqueries and Windows | Codevity

Home
Collections
SQL Interview Preparation for Beginners
SQL Interview Quiz: Logic, Subqueries and Windows

Step 17 of 25 · SQL Interview Preparation for Beginners · Stage 4: Subqueries and window functions

SQL Interview Quiz: Logic, Subqueries and Windows

Ten interview-style questions on NULL logic, NOT IN versus NOT EXISTS, correlated subqueries and window functions.

Medium10 questions· 0 attempts

You'll need to be logged in to submit your answers and track your score.

← PreviousRunning Total with a Window Function Next →SQL Indexes and Query Performance for Beginners

In this collection

Stage 1: Start here
1SQL Interview Roadmap for Beginners: A 30-Day PlanArticle
Stage 2: Foundations
2SQL Fundamentals for Interviews: Keys and ConstraintsArticle
3SELECT, WHERE and NULL: Filtering and Query OrderArticle

4

SQL Basics10 questions · Easy · 15 min

Quiz

Stage 3: Aggregates and joins

5GROUP BY, HAVING and Aggregate FunctionsArticle

6SQL Joins Explained with ExamplesArticle

7Find Duplicate RowssqlSnippet

8Employees and Their Managers (Self Join)sqlSnippet

9SQL Joins and Aggregates10 questions · Medium · 20 minQuiz

Stage 4: Subqueries and window functions

10Subqueries, EXISTS vs IN and CTEs ExplainedArticle

11Customers With No Orders (NOT EXISTS)sqlSnippet

12Window Functions for Interviews: ROW_NUMBER, RANK and LAGArticle

13Nth Highest Salary (DENSE_RANK)sqlSnippet

14Delete Duplicate Rows and Keep OnesqlSnippet

15Latest Order per CustomersqlSnippet

16Running Total with a Window FunctionsqlSnippet

17SQL Interview Quiz: Logic, Subqueries and Windows10 questions · Medium · 20 minQuiz

Stage 5: Indexes, design and transactions

18SQL Indexes and Query Performance for BeginnersArticle

19Filter by Date Without Missing the Last DaysqlSnippet

20Database Normalization: 1NF, 2NF and 3NF with ExamplesArticle

21SQL Transactions, ACID and Isolation LevelsArticle

22Safe UPDATE: Preview, Transaction, VerifysqlSnippet

23SQL Interview Quiz: Indexes, Design and Transactions10 questions · Medium · 20 minQuiz

Stage 6: Interview readiness

2420 SQL Mistakes Freshers Make in InterviewsArticle

25Top 50 SQL Interview Questions for Freshers (with Answers)Article