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
- 21888 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ved
EMPID=123 will show only one row....if you want to see multiple row then use EMPID IN (1,2,3)
Pratically Done.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How to delete an existing database user?
How can we delete Duplicate row in table?
How to drop existing indexes in ms sql server?
What is the Main Difference between ACCESS and SQL SERVER?
How do you debug a procedure in sql server?
According to you what goes into making the best database administrator? : sql server database administration
Can we add our custom code in ssis?
What is difference between getdate and sysdatetime in sql server 2008?
What is advantage data architect?
What are the five major components of a dbms?
Define Wed Edition in SQL Azure?
How to write an inner join with the where clause in ms sql server?
What is the difference between the 2 operating modes of database mirroring?
Name the different type of indexes in sql?
What does truncate do?
