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
- 21867 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
What are the encryption mechanisms in sql server?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to find the login name linked to a given user name?
How to find the source of a table in sql server?
How can you insert values in multiple rows using one Insert statement?
How to fine-tune reports?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How does the report manager work in SSRS?
How can I get data from a database on another server?
Describe in brief sql server monitoring ways.
Difference between drill down and drill through report.
What is difference between inner join and join?
Where are sql server user names and passwords stored in sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
How many types of subqueries are there in sql server?
