Loading lesson path
Concept visual
Start at both ends
❮ SQL Keywords
command tests for the existence of any record in a subquery, and returns true if the subquery returns one or more records. The following SQL lists the suppliers with a product price less than 20:
WHERE EXISTS (SELECT ProductName FROM
Products WHERE SupplierId = Suppliers.supplierId AND Price < 20);The following SQL lists the suppliers with a product price equal to 22:
WHERE EXISTS (SELECT ProductName FROM
Products WHERE SupplierId = Suppliers.supplierId AND Price = 22);❮ SQL Keywords