1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

please correct the error

Discussion in 'Oracle' started by bashainfi, May 14, 2010.

  1. bashainfi

    bashainfi New Member

    Joined:
    May 14, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    select deptno,sum(sal) as tsal
    from scott.emp a
    group by a.deptno
    having job in 'salesman' and 'clerk;
     
  2. bashainfi

    bashainfi New Member

    Joined:
    May 14, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    corrected by myself

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

Share This Page