NTH Highest Value
Intermediate
Analytics needs the second-highest age among users. Two users are tied for the highest age (40), and the tie must count as one level: the answer is the next different age. One user has no age recorded.
Write a query that returns a single value: the second-highest distinct age.
Constraints
- Return a single row with a single column
- Ties count once (use distinct ages)
- Ignore users whose age is NULL
Hints
Hint 1
Sort distinct ages descending and skip the first one.
Hint 2
LIMIT 1 OFFSET 1 returns the second row.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.