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
- 20887 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / saiteja
there is no difference among them.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is named calculation? : sql server analysis services, ssas
What are various limitations of the views?
Can you explain important index characteristics?
What are ddl triggers and types of ddl trigger?
Is it possible in sql table to have more than one foreign key?
What are commonly used odbc functions in php?
What is the difference between Stored Procedures and triggers?
What are the events recorded in a transaction log?
How to connect of datebase with sql express.?
Explain the concepts and capabilities of sql server?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How to call a function from a stored procedure in SQL Server ?
What is difference between equi join and natural join?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What do you understand by physical_only option in dbcc checkdb?
