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
- 20872 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
How use inner join in sql server?
Explain about service Broker functions?
What is a partition key?
What is database replication? What are the different types of replication you can set up in sql server?
Why do we use non clustered index?
What are policy management terms?
What is #temp and @table variable in SQL server?
What is the security principal at the server level that represents your session?
How to set database to be read_only in ms sql server?
Which trace flags are enabled in sql server?
explain databases and sql server databases architecture? : Sql server database administration
How to invoke a trigger on demand?
How many triggers you can have on a table?
When to use Inner join & when to use subquery?
How to replace the Query Result 'Null Value' with a text ?
