IN Vs OR operator which is best to use sql server.

Answer Posted / swaraj

hi i am swaraj.
Ans:-

As per my opinion The IN operator is best B'coz
Due to IN operator at one time multipale requirtment
van satisfied
But Due to OR operator Only one requirtment get satisfied.
So IN operator is Good.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases can we create in a single server?

199


What are the different types of collation sensitivity?

746


How can you list all the table constraints in a database?

697


Can you explain various data region available in ssrs with their use?

720


How to sort the query output with order by clauses in ms sql server?

810






Does sql server use java?

725


What does it mean to invest in the index?

692


What is a data source file?

678


Explain about Views?

763


What are the recovery models for a database?

806


What is reference section?

666


Which is the latest version of sql server and when it is released?

745


What is row_number()?

768


What is log in sql server?

758


What is surrogate key? : sql server analysis services, ssas

861