Friday 12 April 2013

Display the second maximum salary of the employee?

                   select salary from emp where salary=(select max(salary) from emp where salary<(select max(salary) from emp ))
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)