An Intro to SQL Part 5 SQL EXISTS Operator

By Charles McDowell

Comptia Certified Linux Networking Professional.

Cisco Certified Networking Technician.

Microsoft Technology Associate Database Administration

View fullsize

““The cat’s A.I. was realistic, right down to the total lack of loyalty.””

— Dennis E. Taylor, For We Are Many

SQL EXISTS Operator

You can test the existence of a record in a subquery with the exists operator.

If the record exist then the subquery returns it.

EXISTS Syntax

SELECT column

FROM table

WHERE EXISTS

(SELECT column FROM table WHERE statement);