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
- 21034 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / guest
Here both is same but some situvations we want extact value
of one are more values then use in oprate
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the Control Flow in SSIS
How to enter comments in transact-sql statements?
What is the difference between coalesce() & isnull()?
What is a transaction and why is it important?
How to drop an existing schema in ms sql server?
What are the dmvs?
What triggers long term care?
Can group functions be mixed with non-group selection fields in ms sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Which command is used for user defined error messages?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to transfer data from a cursor to variables with a "fetch" statement?
How to write a query with a full outer join in ms sql server?
What is a trace frag? Where do we use it?
