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?
- 15 Answers
- 19404 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jaipal singh
The IN operator allows you to specify multiple values in a
WHERE clause.
if we want to select the persons with a EMPID equal to 1,2
and 3 from the table above.
and simply where clause allow you to select ony whose EmpID
is 123.it is main difference
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
What is data modification?
What are the basic features of a trigger in ms sql server?
What is it unwise to create wide clustered index keys?
What are the steps to insert a table?
what is a live lock? : Sql server database administration
What functions can a view be used to performed?
How to implement service broker?
What is the language structure to add a record to a table?
Tell about MOM Tool(Microsoft Operator Manager)?
Explain the properties of a relational table?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What number sorts of privileges are accessible in sql?
What is log in sql server?
What is difference between oltp and olap?
What is transaction server distributed transaction?
