Practice Amazon SQL Question | Real Coding Interviews

Quick Summary

Identify the second largest unique value in a numeric column.
Handle edge cases like missing values or tied maximums gracefully.
Ensure the output always returns exactly one row with a designated alias.

What This Tests

Handling duplicate values and ranking logic
Subquery nesting and scalar aggregation
Edge case management for empty or insufficient datasets
Proper use of aggregate functions with filtering conditions

Common Patterns

Subquery

Aggregation

Deduplication

Sort

Table: employee

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| employee_id   | integer |
| name          | string  |
| salary        | integer |
+---------------+---------+

employee_id is the primary key for this table.

Test Cases

Input

Output

Expected