please correct the error

bashainfi's Avatar, Join Date: May 2010
Newbie Member
select deptno,sum(sal) as tsal
from scott.emp a
group by a.deptno
having job in 'salesman' and 'clerk;
0
bashainfi's Avatar, Join Date: May 2010
Newbie Member
corrected by myself

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