Skip to content

Latest commit

 

History

History
100 lines (63 loc) · 3.26 KB

README.md

File metadata and controls

100 lines (63 loc) · 3.26 KB

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