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
- 20880 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 is difference between line feed ( ) and carriage return ( )?
What do you understand by coalesce in sql server?
How to bind a view to the schema of the underlying tables?
If a stored procedure is taking a table data type, how it looks?
Can we write trigger for view?
How do you debug a procedure in sql server?
How do I find query history in sql server?
What command would you use to create an index?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is row_number () and partition by in sql server?
What is partitioned view?
What is the need for group functions in sql?
How do I get to sql server configuration manager?
Difference between Inner vs outer joins?
How to receive output values from stored procedures?
