xxxxxxxxxx
Checks for the existence of any record within the subquery, returning true if
one or more records are returned.
Example: Lists any dealerships with a deal finance percentage less than 10.
SELECT dealership_name
FROM dealerships
WHERE EXISTS (SELECT deal_name FROM deals WHERE
dealership_id = deals.dealership_id AND finance_
percentage < 10);
xxxxxxxxxx
SELECT
SupplierName
FROM
Suppliers
WHERE
EXISTS (
SELECT
ProductName
FROM
Products
WHERE
Products.SupplierID = Suppliers.supplierID
AND Price = 22
);
xxxxxxxxxx
SELECT customer_id, first_name
FROM Customers
WHERE EXISTS (
SELECT order_id
FROM Orders
WHERE Orders.customer_id = Customers.customer_id
);