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
- 19505 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 sql server use java?
What purpose does the model database server?
How can delete duplicate records in cte in sql server?
Do you know what is normalization of database? What are its benefits?
What is collation?
How to create dbo table in sql server?
What are the differences between decimal and float in ms sql server?
What is a field name?
What is SQL Azure Firewall?
What are the requirements on sql server network connections?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the default port for SQL Server over a firewall?
How you can get the list of largest tables in a database?
Explain boyce and codd normal form(bcnf)?
What are the purposes of floor and sign functions?
