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?
Answer Posted / chandan
IN operator is used to specify multiple variable.
while in this query both result will be same.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are Row versions of DataRow?
What is a partition key?
What is faster join or union?
What are the requirements to use odbc connections in php scripts?
How to apply cascading referential integrity in place of triggers?
Would you store your query in a ssrs report or a database server? State the reason why?
Explain about integration services of Microsoft SQL server?
Why use update_statistics command in sql server?
Where views are stored in sql server?
What is normalization? What number of normalization shapes are there?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Why does sql studio use a single registered database repository? : sql server management studio
Explain about unique identifier data type in sql server?
What is postgresql server?
Do you know what are acid properties of transaction?