SQL SERVER TUTORIALS
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 ))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment