OR Operator in SQL

• OR requires either conditions to be TRUE. (i.e. any one condition should be satisfied)

Example:

In the above example either conditions can be true for any record to be selected. The employee can have sal >=2000 or his/her department number may be 10 or 20.