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.
Hexaware rounds often probe: Automation + full-stack.
Themes commonly reported in public MNC interview experiences (AmbitionBox / LinkedIn / Glassdoor-style). Practice aloud; keep answers this short in the real round.