"All" and "Any" keywords in SQL
Today we are going to learn two useful keywords from SQL .
1.ALL
It's equivalent to AND condition.
SELECT * FROM EMPLOYEE WHERE AGE > ALL (25,30,35)
2.ANY
It's equivalent to OR condition.
SELECT * FROM EMPLOYEE WHERE AGE > ANY(25,30,35)
Comments
Post a Comment