How to use Multiple OR Operator In SQL
SELECT * FROM CoursesActive
WHERE courseId = 1001
OR courseId =1002
OR courseId = 1003
The Result Looks Like:
Explanation : In this query two OR operators are used with three condition courseId = 1001, courseId =1002, courseId = 1003 when any row with any of the three conditions is true there are only 3 rows.
SQL Server OR Operator
Logical operators are used for combining multiple boolean expressions which are a combination of results of multiple conditions which are formed by the comparators. Some of the logical operators are AND, OR, EXISTS, IN, LIKE, BETWEEN, etc, Logical operators are very frequently used and are very handy for testing multiple conditions. The logical operator OR is used for combining multiple boolean expressions and it returns true only when any one of the conditions is true. It is used primarily with WHERE, CASE, and HAVING clauses by specifying multiple boolean expressions that return any one of the following values True, or False.
Contact Us