how to use the SQL Server EXISTS operator in the condition to test for the existence of rows in a subquery
Shathana. S.R. Answered question
SQL Server EXISTS operator overview
The EXISTS operator returns TRUE if the subquery returns one or more rows. In this syntax, the subquery is a SELECT statement only. As soon as the subquery returns rows, the EXISTS operator returns TRUE and stop processing immediately.
Shathana. S.R. Answered question