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
- 19412 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
What are the disadvantages of primary key and foreign key in SQL?
What are the extra roles available in msdb? : sql server security
How to list all dsn entries on your local machine using odbc_data_source()?
Can We Use Data-grids For Our Report In Ssrs?
What is the difference between dataadapter and datareader?
Does partitioning help performance?
Explain how to use linked server?
What function does a database engine serve in the sql server?
How do you make a trace?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Explain error and transaction handling in sql server?
Find columns used in stored procedure?
What is acid properties?
How to turn on the mssql api module in php?
What is row_number()?
