Multiple choice

What is the significance of 'Exists' clause in SQL query?

  1. It allows multiple values in where clause.

  2. It is used to display records according to specified condition.

  3. It defines that the subquery return atleast one row from the database table.

  4. It is used to sort the data of the table.

  5. None of these

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

It is true about the 'Exists' clause in SQL.