What is the difference between IN and EXISTS operators in
SQL Server?
Answer Posted / navneet sharma
IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table
| Is This Answer Correct ? | 29 Yes | 16 No |
Post New Answer View All Answers
What is the difference between char and varchar2 datatype in sql?
What is sql server query analyzer?
Difference between aggregate functions of sql?
Which joins are sql server default?
What is the most common trace flags used with sql server?
What number sorts of privileges are accessible in sql?
What are the components of dbms?
Write an sql query to find first weekday of the month?
Can I save my report as html, excel or word? : sql server management studio
Explain about SQLOS?
What is difference between view and materialized view?
What is the difference between for xml raw and for xml auto?
Can we use custom code in ssrs?
What is row_number function?
What is sub query and its properties?