Domanda di colloquio di Cognizant

Sql query for second highest salary using subquery.