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 / vandana chand
where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can we join two tables without primary key?
How to delete existing rows in a table?
How to create new tables with "create table" statements in ms sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is a join in sql?
How to find the source of a table in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to generate random numbers with the rand() function in ms sql server?
What is index fragmentation in ms sql server?
How do you delete a data source?
Explain about builtinadministrator?
What is difference statement and preparedstatement?
Write SQL queries on Self Join and Inner Join.
What is public role in sql server?