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

oracle doubt

Discussion in 'Oracle' started by kapoor007, Mar 19, 2007.

  1. kapoor007

    kapoor007 New Member

    Joined:
    Mar 18, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    i m havin a doubt in writing a query to select ename,eno of those employees whose name starts with a or s
    what i feel is
    select ename.eno from emp where ename (like 'a%' or like's%');
    plz solve my doubt
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,293
    Likes Received:
    365
    Trophy Points:
    83
    . should be ,

    Also

    ename (like 'a%' or like's%'); should be ename like 'a%' or ename like's%';
     

Share This Page