LeetCode Problem #177: Nth Highest Salary
Difficulty: Medium
Language: MySQL
Technique: order the desired column from the highest to lowest, then limit one entry and offset the entry using parameter as variable declaration whilst subtracting that variable by one to get the desired result
Functions covered: DISTINCT, ORDER BY DESC, LIMIT OFFSET, DECLARE, SET
Music used:
--------------------------------------------------------------
🎵 Music "Something Blue" by ‘Fool Parsley’
• fool parsley - something blue 🌀 royalty fr...
💿 Listen everywhere:
https://lofihiphop.de/somethingblue
✅ For more Copyright Free Music visit:
https://youtube.tamamusic.com
--------------------------------------------------------------
Tags:
#leetcode #coding #codinginterview #codechallenge #codewithme #solution #codingsolution #database #mysql #sql #db #databasequeries
