Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL ALL Keyword

Concept visual

SQL ALL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALL Keyword

All

The ALL

command returns true if all of the subquery values meet the condition. The following SQL statement returns TRUE and lists the productnames if ALL

Formula

the records in the OrderDetails table has quantity = 10:

Example

SELECT ProductName

FROM Products

WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);

SQL ALL Keyword

Concept visual

SQL ALL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ALL Keyword

All

The ALL

command returns true if all of the subquery values meet the condition. The following SQL statement returns TRUE and lists the productnames if ALL

Formula

the records in the OrderDetails table has quantity = 10:

Example

SELECT ProductName

FROM Products

WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity = 10);

SQL ALL Keyword

SQL ALL Keyword

ALL Keyword

Previous

Next

All

The ALL

Example

SELECT ProductName

FROM Products

Previous

Next

SQL ALL Keyword

SQL ALL Keyword

ALL Keyword

Previous

Next

All

The ALL

Example

SELECT ProductName

FROM Products

Previous

Next