Use RANK() or DENSE_RANK() over salary DESC and filter rank = 3. Or OFFSET/FETCH after DISTINCT salaries. Interviewers care you know duplicates: RANK skips numbers; DENSE_RANK does not.
TCS rounds often probe: Scenario .NET + SQL + Angular.
Themes commonly reported in public MNC interview experiences (AmbitionBox / LinkedIn / Glassdoor-style). Practice aloud; keep answers this short in the real round.