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
- 17983 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
What is data set in report?
What is ddl command?
How can you find out which stored procedures are recompiling?
What does truncate do?
Define Business Edition in SQL Azure?
What the different topologies in which replication can be configured?
Explain transaction server explicit transaction?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is the server name for sql management studio?
Explain the steps to use transact-sql cursor?
What is RMS migrations?
What does null mean?
What is the difference between a fill factor of 100 and 0?
What is the difference between a check constraint and a rule?
How would we use distinct statement? What is its use?
