Get the Second Most Recent Activity (LeetCode 1369)
HardLeetCode 1369 · Top-N per group · Microsoft · 10:26· LeetCode PremiumLeetCode Hard 1369 "Second Most Recent Activity" Microsoft Interview SQL Question with ExplanationMy notes
Sign in to keep private notes on every station, with video timestamps.
Pause here and write your approach in two lines. Compare it with MIK's when the video ends.
Sign in to write your approach →About this video
Video solution for LeetCode 1369 Get the Second Most Recent Activity by Everyday Data Science: Window Functions, Hard. Topics: Database. Watch the explanation, then solve it on LeetCode.
- Difficulty
- hard
- Topics
- Database
- Patterns
- Top-N per group
- Asked at
- Microsoft
- Chapter
- Window Functions
- Duration
- 10:26
Related problems
- The Most Frequently Ordered Products for Each Customer (LeetCode 1596)
- Maximum Transaction Each Day (LeetCode 1831)
- Highest Grade For Each Student (LeetCode 1112)
- The Most Recent Three Orders (LeetCode 1532)
- The Most Recent Orders for Each Product (LeetCode 1549)
- The First Day of the Maximum Recorded Degree in Each City (LeetCode 2314)
- All the Pairs With the Maximum Number of Common Followers (LeetCode 1951)
- Longest Winning Streak (LeetCode 2173)