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
- 18014 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is nonclustered index with included columns ?
Do you know what are the differences between lost updates and uncommitted dependencies?
Explain user defined functions?
What is ddl command?
How to find out what is the default collation in a database?
Difference between Sql server reporting services and Crystal reports?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is the difference between varchar and nvarchar?
Explain system views?
Can We Use Data-grids For Our Report In Ssrs?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is user defined stored procedures?
How to test odbc dsn connection settings?
What is the significance of master, tempdb and model databases?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
