{"id":326,"date":"2018-04-30T21:17:55","date_gmt":"2018-04-30T14:17:55","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=326"},"modified":"2024-03-02T15:39:55","modified_gmt":"2024-03-02T08:39:55","slug":"sql-server-or","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/sql-server-or\/","title":{"rendered":"SQL Server OR Operator"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQL Server OR<\/code> operator to combine two Boolean expressions.<\/p>\n\n\n\n

Introduction to SQL Server OR operator #<\/a><\/h2>\n\n\n\n

The SQL Server OR<\/code> is a logical operator that allows you to combine two Boolean expressions. It returns TRUE<\/code> when either of the conditions evaluates to TRUE<\/code>.<\/p>\n\n\n\n

The following shows the syntax of the OR<\/code> operator:<\/p>\n\n\n

boolean_expression OR boolean_expression<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the boolean_expression<\/code> is any valid Boolean expression that evaluates to true, false, and unknown.<\/p>\n\n\n\n
The following table shows the results of the OR<\/code> operator when you combine TRUE<\/code>, FALSE<\/code>, and UNKNOWN<\/code>:<\/p>\n\n\n\n
<\/th>TRUE<\/th>FALSE<\/th>UNKNOWN<\/th><\/tr><\/thead>
TRUE<\/strong><\/td>TRUE<\/td>TRUE<\/td>TRUE<\/td><\/tr>
FALSE<\/strong><\/td>TRUE<\/td>FALSE<\/td>UNKNOWN<\/td><\/tr>
UNKNOWN<\/strong><\/td>TRUE<\/td>UNKNOWN<\/td>UNKNOWN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
When you use multiple logical operators in an expression, SQL Server always evaluates the OR<\/code> operators after AND<\/a><\/code> operators. But you can use the parentheses ()<\/code> to change the order of the evaluation.<\/p>\n\n\n\n
SQL Server OR operator examples #<\/a><\/h2>\n\n\n\n
We’ll use the following production.roducts<\/code> table from the sample database<\/a>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
1) Basic SQL Server OR operator example #<\/a><\/h3>\n\n\n\n
The following example uses the OR operator to find the products whose list price is less than 200 or greater than 6,000:<\/p>\n\n\n
SELECT<\/span>\n    product_name,\n    list_price\nFROM<\/span>\n    production.products\nWHERE<\/span>\n    list_price < 200<\/span>\nOR<\/span> list_price > 6000<\/span>\nORDER<\/span> BY<\/span>\n    list_price;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"SQL<\/figure>\n\n\n\n
2) Using multiple OR operators #<\/a><\/h3>\n\n\n\n
The following statement uses multiple OR operators to find the products whose brand id is 1, 2, or 4:<\/p>\n\n\n
SELECT<\/span>\n    product_name,\n    brand_id\nFROM<\/span>\n    production.products\nWHERE<\/span>\n    brand_id = 1<\/span>\nOR<\/span> brand_id = 2<\/span>\nOR<\/span> brand_id = 4<\/span>\nORDER<\/span> BY<\/span>\n    brand_id DESC<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"\"<\/figure>\n\n\n\n
You can replace multiple OR<\/a><\/code> operators by the IN<\/a><\/code> operator as shown in the following query:<\/p>\n\n\n
SELECT<\/span>\n    product_name,\n    brand_id\nFROM<\/span>\n    production.products\nWHERE<\/span>\n    brand_id IN<\/span> (1<\/span>, 2<\/span>, 3<\/span>)\nORDER<\/span> BY<\/span>\n    brand_id DESC<\/span>;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
3) Combining the OR operator with the AND operator #<\/a><\/h3>\n\n\n\n
The following example shows how to combine the OR<\/code> operator with the AND<\/code> operator within the same expression:<\/p>\n\n\n
SELECT<\/span> \n    product_name, \n    brand_id, \n    list_price\nFROM<\/span> \n    production.products\nWHERE<\/span> \n    brand_id = 1<\/span>\n      OR<\/span> brand_id = 2<\/span>\n      AND<\/span> list_price > 500<\/span>\nORDER<\/span> BY<\/span> \n    brand_id DESC<\/span>, \n    list_price;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"SQL<\/figure>\n\n\n\n
In this example, we used both OR<\/code> and AND<\/code> operators. As always, SQL Server evaluated the AND<\/code> operator first. Therefore, the query returned the products whose brand id is 2 and the list price is greater than 500 or those whose brand id is 1.<\/p>\n\n\n\n
To find the products whose brand id is 1 or 2 and list price is greater than 500, you use the parentheses as shown in the following query:<\/p>\n\n\n
SELECT<\/span>\n    product_name,\n    brand_id,\n    list_price\nFROM<\/span>\n    production.products\nWHERE<\/span>\n    (brand_id = 1<\/span> OR<\/span> brand_id = 2<\/span>)\n     AND<\/span> list_price > 500<\/span>\nORDER<\/span> BY<\/span>\n    brand_id;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"\"<\/figure>\n\n\n\n
Summary #<\/a><\/h2>\n\n\n\n
    \n
  • Use the SQL Server OR<\/code> operator to combine two Boolean expressions.<\/li>\n\n\n\n
  • The OR<\/code> operator returns TRUE<\/code> if one of the expressions is TRUE<\/code>.<\/li>\n\n\n\n
  • By default, SQL Server evaluates the OR<\/code> operators after the AND<\/code> operators within the same expression. But you can use parentheses ()<\/code> to change the order of evaluation.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t