SQL Any

SQL Any

This tutorial covers SQL Any operator.

The “any” operator is part of the logical operators.

It compares single column values with a scalar value. The “any” operator is equivalent to the “some” operator (check here).

For more information on operators here.

Here we use two tables. First is the table “student_info” from the previous tutorials, and the second is a table named “grade“, linked to the first table with a foreign key.

id	firstName	lastName	age
1	John	Smith	21
2	Patrick	Casey	26
3	Sam	Adams	19
4	Mike	Garcia	NULL
5	Patrick	Dumont	21

id	subjectName	grade	passed	studentID
1	History	C	1	1
2	Physics	A	1	2
3	History	F	0	3
4	Biology	A	1	NULL
5	Biology	E	1	5

Any

The operator “any” functions as a comparison.

It returns TRUE if any of the conditions are met.

Below is an example.

SELECT firstName, lastName FROM student_info
WHERE id = ANY (SELECT studentID FROM grade WHERE grade = 'A');

The above query displays all first and second student names that match grade A in the “grade” table.

firstName	lastname
Patrick	Casey

Please note the 4th student does not show as the id cell is empty (NULL).

We can combine the above statement with the “in” logical operator.

This will allow multiple grade selections.

SELECT firstName, lastName FROM student_info
WHERE id = ANY (SELECT studentID FROM grade WHERE grade IN ('A', 'B', 'C'));

firstName	lastname
John	Smith
Patrick	Casey

---

Next: SQL All