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.
Type: Posts; User: sherocks4me; Keyword(s):
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.