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
- 21477 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
How do you create an execution plan?
Explain the disadvantages/limitation of the cursor?
How to count duplicated values in a column in ms sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
What is unpivot?
Explain boyce and codd normal form(bcnf)?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How do you make a trace?
Explain triggers?
What is the difference between truncate and delete commands?
What is the difference between mysql and mysqli?
how to avoid cursors? : Sql server database administration
How to insert new line characters into strings?
What is the purpose of sql profiler in sql server? : sql server database administration
Define indexes?
