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
- 21465 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
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
How to create indexed view?
How to backup SQL Server Reporting Services ?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the properties of the transactions?
Explain about thread and memory management process of SQL?
What are the different types of sql server replication? : sql server replication
What is etl - extraction, transformation, and loading?
Define full outer join in sql server joins?
Does any body please help me what question's have asked for SSRS in the interview?
Can we return Data from 4(more than 1) tables in stored procedure?
What is the purpose of forms?
What will happen if a column containing char type data is changed to the nchar data type?
How can we rewrite sub-queries into simple select statements or with joins?
What is the difference between char and varchar2 datatype in sql?
