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
- 17970 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 the difference between clustered and non-clustered indexes in ms sql server?
Explain relational data?
Do you know how to store and query spatial data?
What are examples of triggers?
Explain “row_number()” in sql server with an example?
How to install sql server 2005 express edition?
What are the functions in sql server?
What are drillthrough reports?
What are the acid properties?
How to connect a database with sql express.?
How will you hide an attribute? : sql server analysis services, ssas
How do I find the sql server version?
Does union all remove duplicates?
What is dirty read?
Can we use having clause without group by?
