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
- 17963 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / g.m. ershad
1)select * from test2 where id=44
Output -
ID NAME
44 Ershad
2) sELECT * FROM test2 WHERE ID IN (44)
Output -
ID NAME
44 Ershad
both will return same output
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What is the recovery model?
What are the different types of locks in the database?
What are the instances when triggers are appropriate?
how many type of indexing in database?
Does sql server 2000 full-text search support clustering?
What is surrogate key? : sql server analysis services, ssas
What is bit data type? What's the information that can be stored inside a bit column?
What are different types of views?
Which Model uses the SET concept
How do I start sql server agent automatically?
What do we have to check in database testing?
Is sql server implemented as a service or an application? : Sql server database administration
What does top operator do?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is ms sql server triggers?
