MS Sql Server Tutorials | Examples | Interview Questions Tutorial

MS SQL Server EXIST Operator

❮ Previous Next ❯

EXISTS Operator is used to check the existence of any record or result of the correlated nested query.
If subquery return one or more records the EXISTS operator returns TRUE.
If the subquery returns a zero result the EXISTS operator returns FALSE.
Syntax:

WHERE EXISTS(subquery);

Example:

We have two tables 'student' and 'staff' in the University database

SELECT * FROM [University].[dbo].[Student] WHERE EXISTS (SELECT * FROM [University].[dbo].[Staff] WHERE Student.Branch = Staff.Branch);

❮ Previous Next ❯