Loading lesson path
Concept visual
Start at both ends
operator is used in a WHERE clause to check whether a subquery returns any rows.
operator evaluates to TRUE if the subquery returns at least one row, and FALSE otherwise.
column_name(s)
table_name WHERE EXISTS ( subquery
);Below is a selection from the "Products" table in the Northwind sample database:
10 boxes x 20 bags 18.00
Formula
24 - 12 oz bottles19.00
Formula
12 - 550 ml bottles10.00
Formula
48 - 6 oz jars22.00
36 boxes 21.35 And a selection from the "Suppliers" table: