Frequently asked SQL Queries

1. Select the second largest salary from the employee table.

> select max(salary) from employee
 where salary <  (select max(salary) from employee);