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;
     
    bashainfi, May 14, 2010
    SHARE #1
  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;
     
    bashainfi, May 14, 2010
    SHARE #2

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice