In a subquery, which type of comparison operator can be used to compare a single value with a result set?

  • BETWEEN
  • EXISTS
  • IN
  • LIKE
In a subquery, the EXISTS operator can be used to compare a single value with a result set. The EXISTS operator returns true if the subquery returns any rows, otherwise false. It is commonly used in correlated subqueries to check for the existence of a particular condition. For example, you can use EXISTS to check if there are any employees in a department with a certain job title.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *