What is the difference between IN and EXISTS operators in
SQL Server?
Answer Posted / raja
in operator returns the condition satisfied rows only
But in exists operator if any condition satisfied it will returns all the rows.
Is This Answer Correct ? | 6 Yes | 15 No |
Post New Answer View All Answers
What is tabulation?
What are four major operators that can be used to combine conditions on a where clause?
How secure is sql server database?
When a primary key constraint is included in a table, what other constraints does this imply?
How many joins in sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
How to use subqueries with the exists operators in ms sql server?
what is a transaction and what are acid properties? : Sql server database administration
What is triggers in ms sql server?
What are logical database components? : SQL Server Architecture
How will you add a dimension to cube? : sql server analysis services, ssas
Mention the differences between sql server and mysql.
Is truncate autocommit?
Do you know what are acid properties?
How do you clear a log file?