1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between WHERE AND IN?
OR
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?

Question Posted / abinash

Answers were Sorted based on User's Feedback



What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / guest

Here both is same but some situvations we want extact value
of one are more values then use in oprate

Is This Answer Correct ?    0 Yes 0 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / vandana chand

where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / vandana chand

where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.

Is This Answer Correct ?    0 Yes 0 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / ved

EMPID=123 will show only one row....if you want to see multiple row then use EMPID IN (1,2,3)


Pratically Done.

Is This Answer Correct ?    3 Yes 5 No

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELE..

Answer / saiteja

there is no difference among them.

Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More SQL Server Interview Questions

What are the events recorded in a transaction log?

0 Answers  

what is normalization? what is denormalization?

9 Answers   Satyam,

Define right outer join?

0 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers  

What does <> symbol mean?

0 Answers  




What are the different authentication modes in sql server?

0 Answers  

What causes index fragmentation?

0 Answers  

What is 2nf normalization form?

0 Answers  

Explain about link server in sql server?

0 Answers  

How to change server name in sql server?

0 Answers  

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories