hi all
display details of employes having sal> the avg sal of any of the department
hi all
display details of employes having sal> the avg sal of any of the department
Select * from emp where sal > (select avg(sal) from emp)
** you can alternatively use where clause in either main or sub query.
hope it will work.