Practice Microsoft SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

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

Test Cases

Input

-

Output

-

Expected

-