Leetcode
LC 176 & LC 177 & LC 178 & LC 1077 & LC 1596 LC 176 & LC 177 & LC 178 & LC 1077 & LC 1596
The following advanced-level SQL problems are about ‘Rank Function’. LeetCode 176Second Highest Salary (Medium) [link] S
2022-04-04 SQL
SQL-Advanced Window Functions
LC 1341 & LC 1867 LC 1341 & LC 1867
The following basic-level SQL problems are about ‘subquery’. LeetCode 1341Movie Rating (Medium) [link] Note: UNION ALL k
2022-04-03 SQL
SQL-Basic
LC 46 & LC 47 (Template) LC 46 & LC 47 (Template)
Solution to LeetCode 46 Permutations and LeetCode 47 Permutation II. LeetCode 46Permutations (Medium) [link] The differe
2022-04-02 Recursion
Recursion Template Backtracking
LC 116 & LC 542 & LC 617 & LC 695 & LC 733 & LC 994 LC 116 & LC 542 & LC 617 & LC 695 & LC 733 & LC 994
Solution to LeetCode 116 Populating Next Right Pointers in Each Node, LeetCode 542 01 Matrix, LeetCode 617 Merge Two Bin
2022-04-01 Graph
DFS BFS
LC 3 & LC 438 & LC 567 (template) LC 3 & LC 438 & LC 567 (template)
Solution to LeetCode 3 Longest Substring Without Repeating Characters, LeetCode 438 Find All Anagrams in a String, and L
2022-03-31 String
Template Sliding Window
LC 1045 & LC 1321 & LC 1549 LC 1045 & LC 1321 & LC 1549
The following basic-level SQL problems are about ‘subquery’. LeetCode 1045Customers Who Bought All Products (Medium) [li
2022-03-30 SQL
SQL-Basic
LC 180 & LC 1459 & LC 1988 LC 180 & LC 1459 & LC 1988
The following basic-level SQL problems are about ‘inequality linking’. LeetCode 180Consecutive Numbers (Medium) [link] T
2022-03-29 SQL
SQL-Basic
LC 181 & LC 603 & LC 1731 & LC 1747 LC 181 & LC 603 & LC 1731 & LC 1747
The following basic-level SQL problems are about ‘inequality linking’. LeetCode 181Employees Earning More Than Their Man
2022-03-28 SQL
SQL-Basic
LC 167 & LC 189 & LC 283 & LC 344 & LC 557 & LC 977 LC 167 & LC 189 & LC 283 & LC 344 & LC 557 & LC 977
Solution to LeetCode 167 Two Sum II - Input Array Is Sorted, LeetCode 189 Rotate Array, LeetCode 283 Move Zeros, LeetCod
2022-03-27 Array
Double Pointers
LC 626 & LC 1164 & LC 1294 & LC 1783 LC 626 & LC 1164 & LC 1294 & LC 1783
The following basic-level SQL problems are about ‘linking’. More: MOD LeetCode 626Exchange Seats (Medium) [link] Using C
2022-03-26 SQL
SQL-Basic
LC 184 & LC 570 & LC 580 & LC 1264 & LC 1280 LC 184 & LC 570 & LC 580 & LC 1264 & LC 1280
The following basic-level SQL problems are about ‘linking’. LeetCode 184Department Highest Salary (Medium) [link] Using
2022-03-25 SQL
SQL-Basic
LC 619 & LC 1112 & LC 1398 & LC 1607 & LC 1440 LC 619 & LC 1112 & LC 1398 & LC 1607 & LC 1440
The following basic-level SQL problems are about ‘linking’. LeetCode 619Biggest Single Number (Easy) [link] SELECT(
2022-03-24 SQL
SQL-Basic
11 / 18