ANY and ALL Operators

ANY and ALL

• > ANY = greater than at least one.
• > ALL = greater than every one.

Examples

-- marks greater than ANY class-10 student (i.e. > the minimum)
SELECT name FROM students
WHERE marks > ANY (SELECT marks FROM students WHERE class = '10');

-- marks greater than ALL class-10 students (i.e. > the maximum)
SELECT name FROM students
WHERE marks > ALL (SELECT marks FROM students WHERE class = '10');

Summary

• > ANY = greater than the smallest in the set.
• > ALL = greater than the largest in the set.

ANY और ALL

• > ANY = कम से कम एक से बड़ा।
• > ALL = हर एक से बड़ा।

Examples

-- class-10 के ANY student से ज़्यादा marks (यानी > minimum)
SELECT name FROM students
WHERE marks > ANY (SELECT marks FROM students WHERE class = '10');

-- class-10 के ALL students से ज़्यादा marks (यानी > maximum)
SELECT name FROM students
WHERE marks > ALL (SELECT marks FROM students WHERE class = '10');

सारांश

• > ANY = set के सबसे छोटे से बड़ा।
• > ALL = set के सबसे बड़े से बड़ा।