LeetCode MEDIUM 176 Second Highest Salary Summary
Generated by Codex with GPT-5
Quick facts
- Difficulty:
MEDIUM - Problem: Second Highest Salary
- Main tags:
Database,SQL
What the problem is really asking
There is an Employee table with a salary column. The task is to return the second-highest distinct salary value.
That word “distinct” is the whole trick.
If the largest salary appears many times, it still counts as only one rank. So this is not:
Continue ...