1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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