Exist Operator in Sql Server?

Total Post:123

Points:615

 534  View(s)
Ratings:
Rate this:
  1. Exist Operator in Sql Server?

    The EXISTS operator is used to test for the existence of any record in a subquery.

    The EXISTS operator returns true if the subquery returns one or more records.

    EXISTS Syntax
    
    SELECT column_name(s)
    FROM table_name
    WHERE EXISTS
    (SELECT column_name FROM table_name WHERE condition);

Answer