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
- 21884 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 are the pre-defined functions in the sql server?
How to return the top 5 rows from a select query in ms sql server?
How to define the name and server for a new dsn?
Is there any difference between the primary key and unique key?
Can a trigger be created on a view?
What are examples of triggers?
how would you improve etl (extract, transform, load) throughput?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
where the connection string store in the database
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the difference between ddl,dml and dcl commands?
Explain how to send email from sql database?
How many categories of functions based their return modes?
How to add an address record into adventureworkslt?
What are built in functions?
