"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

Popular posts from this blog

Types of Architects

Basic measurements

Search html table contents based on its td using Jquery