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 / saiteja
there is no difference among them.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
How to connect a database with sql express.?
How to generate create procedure script on an existing stored procedure?
Why use triggers?
How to use subqueries in the from clause in ms sql server?
What is shared lock?
How to enforce security in sql server? : sql server security
Define ACID properties in a Database?
What is 4nf in normalization form?
What is the difference between varchar and varchar types?
Explain how you can deploy an SSRS report?
Explain four layers of abstraction microsoft architectured?
What is the recovery model?
How do I save a stored procedure in sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What is the difference between ddl and dml?