Tuesday, August 30, 2011

SQL Query to retrieve second highest salary from table



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

No comments:

Post a Comment