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
- 19405 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / soumya ghosh
Both of them will return the same record
But as per the first sentence of the question, WHERE is a Clause whereas IN is a Operator. That is the difference between both.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
between cast and convert which function would you prefer and why?
How many full-text indexes can a table have?
What is row_number()?
Explain indexes disadvantages?
How can change procedure in sql server?
Can you index views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why should one not prefix user stored procedures with ‘sp_’?
What is the purpose of the tempdb database?
Can you explain what are commit and rollback in sql?
How to fine-tune reports?
Explain the types of indexes.
What does set rowcount do?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How sql server enhances scalability of the database system?
