googletag.cmd.push(function() googletag.display('div-gpt-ad-1422003450156-2'); );

SQL EXISTS Keyword

❮ SQL Keywords Reference

EXISTS

The EXISTS 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:

SELECT SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM
Products WHERE SupplierId = Suppliers.supplierId AND Price < 20);

Try it Yourself »

The following SQL lists the suppliers with a product price
equal to 22:

SELECT SupplierName
FROM Suppliers
WHERE EXISTS (SELECT ProductName FROM
Products WHERE SupplierId = Suppliers.supplierId AND Price = 22);

Try it Yourself »

❮ SQL Keywords Reference

9LsAzcVF3oFsF67G nS i3nfmz5CqV3g9,Rj08Ab5UVA f0U jHFQQ O7 j