bdfd/Section3.4.1-Gitbook_Template

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.

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 Topcis
  • Basic
  • SQL Command
  • Join
  • Subquery
  • Window Function
  • CASE WHEN / IIF
  • OFFSET FETCH
  • PIVOT & UNPIVOT
  • Variable
• LeetCode SQL Questions by ID

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