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
- 20885 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
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to find the login name linked to a given user name?
what is create database syntax? : Sql server database administration
What are the properties of the transaction?
Explain the various types of concurrency problem?
How do I open port 1433?
What is sql server profiler trace data file?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Who is the owner of a schema in ms sql server?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
List some advantages and disadvantages of stored procedure?
How do you delete a trigger?
What is filtered index?
What are system databases into sql server (2005/2008) : sql server database administration
What are the types of subquery?
