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

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.

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.

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')

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

What is row_number()?

0 Answers  

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

What is difference between foreign key and unique key?

0 Answers  

---

What is a recursive stored procedure in sql server?

0 Answers  

---

What is update_statistics command?

0 Answers  

---

How to enforce security in sql server? : sql server security

0 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---