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?
Answer Posted / soumya ghosh
Both of them will return the same record
But as per the first sentence of the question, WHERE is a Clause whereas IN is a Operator. That is the difference between both.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the difference between clustered and a non-clustered index?
Define self join in sql server joins?
Should you normalize audio?
What is subquery explain with example?
What will be query used to get the list of triggers in a database?
What is the Disadvantage of indexed sequential file.
What is the command dbcc checkdb used for?
What is the difference between migration and upgradation in sql server?
how you can get the list of largest tables in a database? : Sql server administration
How is a full-text index updated?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Why is the need for data conversion transformations?
Explain the different types of backups available in sql server? : sql server database administration
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is user-defined functions? What are the types of user-defined functions that can be created?