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
- 21431 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
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 difference between ddl,dml and dcl commands?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
what are the core components of SSRS?
What is the difference between varchar and nvarchar?
what is a correlated sub-query? : Sql server database administration
How to convert numeric values to integers in ms sql server?
What is a heap?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to count groups returned with the group by clause in ms sql server?
What is normalization and its types?
What is schemabinding a view?
What is isnull() operator?
What is bit data type? What's the information that can be stored inside a bit column?
How to send a ssrs report from ssis?
What is unique key constraint?
