Ace Test Series: Databases - Sql

Question

Answer 1

Answer : (c) 3- Rows

It will return all the rows, as 0 value of count is cosidered to be the Existing value,so TRUE is returned.

• WHERE EXISTS tests for the existence of any records in a subquery.
• EXISTS returns true if the subquery returns one or more records.
• EXISTS is commonly used with correlated subqueries.

Comments

Joining condition is not mentioned so will it give error??