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 is normalization and its types?

0 Answers  

---

What is 3nf normalization form?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

What is a sub-query? When would you use one?

3 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How to access the inserted record of an event?

0 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is nonclustered index on computed columns?

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What is log ldf?

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---