IN Vs OR operator which is best to use sql server.

Question Posted / preethi

4 Answers
12026 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

IN Vs OR operator which is best to use sql server...

Answer / harinireddy

in is peferable bcoz
by using in we can write set of values at time n check it
where as when we use or we need to mention for each n every
value
like ...
select emp_id from employee where emp_id in(1,2,3,4..)
but in case of or...
select emp_id from employee where emp_id=1 or emp_id=2 or
emp_id=3 or emp_id=4...

Is This Answer Correct ?

9 Yes

0 No

IN Vs OR operator which is best to use sql server...

Answer / swaraj

hi i am swaraj.
Ans:-

As per my opinion The IN operator is best B'coz
Due to IN operator at one time multipale requirtment
van satisfied
But Due to OR operator Only one requirtment get satisfied.
So IN operator is Good.

Is This Answer Correct ?

2 Yes

1 No

IN Vs OR operator which is best to use sql server...

Answer / swaraj

Is This Answer Correct ?

1 Yes

1 No

IN Vs OR operator which is best to use sql server...

Answer / sandeep rana

Both are used for different purposes like...

select * from table where data in(1,2,3,4,5,6)

select * from table where data in(1,2,3,4,5,6) or data1
like('%s','%t')

Is This Answer Correct ?

0 Yes

0 No

Post New Answer