469,167 Members | 2,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

is this syntax right?

Here this Syntax doesn't have where clause. SO is it possible to specify a condition without where clause also?. Can someone help me pls.

select empname from employess empname like 'jack%';
Jun 5 '07 #1
1 1731
frozenmist
179 Expert 100+
Here this Syntax doesn't have where clause. SO is it possible to specify a condition without where clause also?. Can someone help me pls.

select empname from employess empname like 'jack%';
Hi Sush,
You have to give where clause for the condition.
You can also have the query using case, if you dont want to use where...

Expand|Select|Wrap|Line Numbers
  1. select case when empname like 'jack%' then empname end as empname from employess ;
  2.  
Cheers
Jun 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Steve | last post: by
699 posts views Thread by mike420 | last post: by
14 posts views Thread by Sandy Norton | last post: by
37 posts views Thread by Bengt Richter | last post: by
reply views Thread by Thiko | last post: by
18 posts views Thread by robert | last post: by
8 posts views Thread by Smithers | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.