ZS Associates interview question

They asked query of SQL like 3rd highest salary