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

What are the components of dbms?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

What functions can a view be used to performed?

0 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

How to truncate a table first before running a package?

1 Answers  

---

How will you know when statistics on a table are obsolete?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

What are the advantages of using cte?

0 Answers  

---