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