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
- 19426 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ved
EMPID=123 will show only one row....if you want to see multiple row then use EMPID IN (1,2,3)
Pratically Done.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are the different kinds of ssrs reports?
What is difference between rollback immediate and with no_wait during alter database?
What is meant by indexing?
What happens if null values are involved in datetime operations?
What is a deadlock and what is a live lock?
What do you understand by physical_only option in dbcc checkdb?
how to create “alternate row colour”?
Write a query for primary key constraint with identity key word?
Explain logical operators in sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Tell about MOM Tool(Microsoft Operator Manager)?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Are connections to sql server encrypted?
What is ddl command?
