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 / mohan
both are same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is a traditional network library for sql servers? : Sql server database administration
Explain insert into select statement?
Can you use order by when defining a view?
How to rebuild all indexes on a single table?
What are .mdf files?
What are ddl (data definition language) statements for tables in ms sql server?
What are binary string data types in ms sql server?
What are relationships and mention different types of relationships in the dbms
What is repeatable read?
Can a table have 2 foreign keys?
Why SQL Agent is used?
What is equi join with example?
What is normalization of database?
What is a cube? : sql server analysis services, ssas
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration