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
- 21858 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
Explain important index characteristics?
How and why use sql server?
What are transactions and its controls?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are indexes in ms sql server?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to check if a table is being used in sql server?
How to start sql server browser service?
Explain in brief about Microsoft SQL server?
What are the types of sql server?
What are drillthrough reports?
What is parameterized reports in ssrs ?
How to enter date and time literals in ms sql server?
explain how to create a new schema in a database? : Sql server database administration
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
