Cognizant Interview Question

Sql query for second highest salary using subquery.