Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   please correct the error (http://www.go4expert.com/forums/correct-error-t22099/)

bashainfi 14May2010 11:32

please correct the error
 
select deptno,sum(sal) as tsal
from scott.emp a
group by a.deptno
having job in 'salesman' and 'clerk;

bashainfi 14May2010 15:50

Re: please correct the error
 
corrected by myself

select deptno, sum(sal) as tsal
from scott.emp a
where job in ('SALESMAN','CLERK')
group by a.deptno;


All times are GMT +5.5. The time now is 02:34.