Exist Operator in Sql Server?

Manish Kumar 1247 15 Dec 2017

Manish Kumar

Other

Manish Kumar 15 Dec 2017

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);

interview