Syntax of EXISTS operator in SQL-
SELECT <column_name(s)> FROM <table_name>
WHERE EXISTS
(SELECT <column_name(s)> FROM <table_name> WHERE <condition>);
Example of EXISTS operator in SQL-
SELECT SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM Products WHERE Products.SupplierID=Suppliers.supplierID AND Price>10);
–This SQL statement will lists the suppliers with a product price >10.