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,336
    Likes Received:
    377
    Trophy Points:
    83
    . should be ,

    Also

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

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.
    Dismiss Notice