Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21433 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chandan
IN operator is used to specify multiple variable.
while in this query both result will be same.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to drop an existing stored procedure in ms sql server?
What is mean by dml?
What is filestream?
How to end a stored procedure properly in ms sql server?
Explain about sql server login?
What are the advantages of paper records?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How to fine-tune reports?
How to add code to the existing article (using improve article)?
How to create a new schema in a database?
Explain what is the use of custom fields in report?
When to use Inner join & when to use subquery?
What is log cache in sql server?
Do you know what are acid properties?
What is 2nf in normalization?
