What is the EXISTS operator

Question

Hi!!

Can someone tell me what is the EXISTS Operator?

Answer 1

Exists operator is used to test if a record exists or not.

Syntax:

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