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
- 20886 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 do I get to sql server configuration manager?
What is the difference between update lock and exclusive lock?
Which tcl commands are available on the sql server?
How to count groups returned with the group by clause in ms sql server?
What is difference between cte and view?
What is a field in a table?
Explain Geometry datatype in sql server 2008 with example
What are data driven subscriptions?
What is an indexing strategy?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What is difference between getdate and sysdatetime in sql server 2008?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is the difference between function and stored procedure in sql server?
How to execute function in stored procedure sql server?
What is normalization? What number of normalization shapes are there?
