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
- 19475 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
Does the order of columns in update statements matter?
How to convert binary strings into integers in ms sql server?
What is acid properties?
How do you check sql server is up and running?
What is meant by Active-Passive and Active-Active clustering setup?
What is row_number function?
What is 2nf example?
What command would you use to add a column to a table in sql server?
How to create database with physical files specified in ms sql server?
How to disconnect from a sql server using mssql_close()?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to create prepared statements using odbc_prepare()?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What are the indexes in sql server?
