Skip to content

This repository is for everyone who is preparing for SQL interview questions. Common pitfalls, anti-patterns and handy tricks are discussed. Sample databases and answer playground are provided.

License

Notifications You must be signed in to change notification settings

bdfd/Section3.4.1-Gitbook_Template

Repository files navigation

README

Curretnly Working on Upload Leetcode SQL Question

Intro

Finished ALL LeetCode SQL questions, and reorder to Summarize all questions based on difference topics.
Checkout at SQL Question Website

This github aims to Summary for SQL Interview Effeciently, and focus Specific Topic as needed, e.g. Join, Window Function, Recursive CTE and etc.

If you with questions by ID order, you could jump to LeetCode SQL Questions by ID where I list all questions coverred in this repository.

And for the first draft, I mainly focus on MySQL Currently.

Table of Content

LeetCode SQL Questions by Topics

Basic

# Title Difficulty Solution
182 Duplicate Emails Easy Soln.

SQL Command

# Title Difficulty Solution

Join

  • Simple Join
# Title Difficulty Solution
  • Advanced Join
# Title Difficulty Solution

Subquery

  • Simple Subquery
# Title Difficulty Solution
  • Advanced Subquery
# Title Difficulty Solution
  • Recursive CTE
# Title Difficulty Solution

Window Function

# Title Difficulty Solution

CASE WHEN or IIF

# Title Difficulty Solution

OFFSET FETCH

# Title Difficulty Solution

PIVOT and UNPIVOT

# Title Difficulty Solution

Variable

# Title Difficulty Solution

LeetCode SQL Questions by ID

# Title Difficulty Solution

About

This repository is for everyone who is preparing for SQL interview questions. Common pitfalls, anti-patterns and handy tricks are discussed. Sample databases and answer playground are provided.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published