1. 

   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

    

   kapoor007, Mar 19, 2007

   SHARE #1
2. 

   shabbir Administrator Staff Member

   Joined:

   Jul 12, 2004

   Messages:

   15,371

   Likes Received:

   387

   Trophy Points:

   83

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

    

   shabbir, Mar 19, 2007

   SHARE #2

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in