EXIST

•    The EXISTS operator is utilized to determine whether any records exist in a subquery, returning TRUE if the subquery yields one or more records.

 

          SELECT column_name(s)

          FROM table_name

          WHERE EXISTS

          (SELECT column_name FROM table_name WHERE condition);