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
- 21845 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abinash
Jaipal Sing: Lets say I will keep only one value (123) in IN
clause. In this case what is the real difference??
This is how Question asked to me!! and I am answer less...
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain what is log shipping?
What is the difference between online clustering and Offline clustering?
how would you store your query in an SSRS report or a Database server?
is there a column to which a default can't be bound? : Sql server database administration
What is a functions and types in sql server?
What is Command line parameters in PLSQL.?
Can we use trigger new in before insert?
What is the largest component inside a field?
What is the use of group by clause?
Explain what is analysis service repository?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is read committed?
What are different types of raid levels?
What is the difference between index seek vs. Index scan?
What happens if null values are involved in datetime operations?
