An Intro to SQL Part 6 SQL ANY and ALL Operators

By Charles McDowell

Comptia Certified Linux Networking Professional.

Cisco Certified Networking Technician.

Microsoft Technology Associate Database Administration

View fullsize

““The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn. ”
”

— Alvin Toffler

SQL ANY and ALL Operators

You use the Any and All operators in Where or having clauses.

When the operator is true, the query will return values that meet the condition.

The all operator is met when all of the subquery values met.

ANY Syntax

SELECT column

FROM table

WHERE column operator ANY

(SELECT column_ FROM table WHERE statement);

ALL Syntax

SELECT column
FROM table
WHERE column operator ALL
(SELECT column_ FROM table WHERE statement);
Must use the following comparison <>, !=, >, >=, <, or <=).