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
- 20888 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 can I add Reporting Services reports to my application?
What is join query?
What is the benefit of normalization?
what are the three command line utilities and what are their primary functions?
Can you explain what is the use of custom fields in report?
Can a table be created inside a trigger?
How to create hyperlink from returned sql query ?
How does a profiler work?
What is snapshot replication?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to connect of datebase with sql express.?
What command is used to delete a table from the database in the sql server and how?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to create an identity column?
List some major differences between triggers and stored procedures?
