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
- 20865 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
What is shrink log file?
What Are the Main Features of SQL Azure?
How do I install only the client tools of sql server 2000?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What are the database roles? : sql server security
How to implement service broker?
Explain following error properties?
What is difference between join and natural join?
What is the difference between substr and charindex in the sql server?
How do I connect to sql server database?
Define Unique Key?
Can a database be shrunk with users active?
What is updatable resultset?
How to verify a login name with sqlcmd tool?
What does null mean?
