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
- 21462 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / g.m. ershad
1)select * from test2 where id=44
Output -
ID NAME
44 Ershad
2) sELECT * FROM test2 WHERE ID IN (44)
Output -
ID NAME
44 Ershad
both will return same output
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Where sql server usernames and passwords are stored in a sql server?
Define master database?
Is null vs coalesce?
how many no of arguments can be passed in procedures and functions
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Different types of keys in SQL?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What does this statement do @@rowcount?
What are types of scd? : sql server analysis services, ssas
What are data files?
Why do we backup Active Directory ?
What is the dbcc command and why is it used?
What is candidate key with example?
What does the on update no action do?
What is data file in computer?
