SQL SERVER TUTORIALS
Friday, 12 April 2013
To get the employees Minimum and Maximum salaries of all employees
select salary from emp where salary in (select min(salary) from emp)
union
(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