Pregunta de entrevista de Cognizant

Sql query for second highest salary using subquery.