{"id":216,"date":"2019-03-27T07:44:52","date_gmt":"2019-03-27T15:44:52","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=216"},"modified":"2020-04-11T06:59:54","modified_gmt":"2020-04-11T14:59:54","slug":"db2-and","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-and\/","title":{"rendered":"Db2 AND"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the Db2 AND<\/code> operator to combine multiple Boolean expressions.<\/p>\n\n\n\n

Introduction Db2 AND operator<\/h2>\n\n\n\n

The AND<\/code> operator is a logical operator that combines two Boolean expressions or predicates. You use the AND<\/code> operator to specify that a search must satisfy both conditions.<\/p>\n\n\n\n

The following illustrates the AND<\/code> operator syntax:<\/p>\n\n\n

boolean_expression1 AND boolean_expression2\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the boolean_expression1<\/code> and boolean_expression2<\/code> evaluate to true, false, and unknown.<\/p>\n\n\n\n
This table displays the result when combining true, false, and unknown values using the AND<\/code> operator:<\/p>\n\n\n\n
<\/th>TRUE<\/th>FALSE<\/th>UNKNOWN<\/th><\/tr><\/thead>
TRUE<\/strong><\/td>TRUE<\/td>FALSE<\/td>UNKNOWN<\/td><\/tr>
FALSE<\/strong><\/td>FALSE<\/td>FALSE<\/td>FALSE<\/td><\/tr>
UNKNOWN<\/strong><\/td>UNKNOWN<\/td>FALSE<\/td>UNKNOWN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
If you use both AND<\/code> and OR<\/code> operators in an expression, Db2 evaluates the AND<\/code> operator first. However, you can change the order of evaluation using parentheses.<\/p>\n\n\n\n
To negate the AND<\/code> operator, you use the NOT<\/code> operator as follows:<\/p>\n\n\n
NOT (boolean_expression1 AND boolean_expression2)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The AND<\/code> operator is often used in the WHERE<\/a><\/code> clause to form the search condition for the SELECT<\/a><\/code>, UPDATE<\/a><\/code>, and DELETE<\/a><\/code> statement.<\/p>\n\n\n\n
Db2 AND operator examples<\/h2>\n\n\n\n
Let’s use the books<\/code> table from the sample database for the demo.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
1) Db2 AND operator example<\/h3>\n\n\n\n
This example uses the AND<\/code> operator to find the books whose ratings are between 4 and 5:<\/p>\n\n\n
SELECT<\/span>    \n    title, \n    rating, \n    total_pages\nFROM<\/span>    \n    books\nWHERE<\/span> rating >= 4<\/span>\n        AND<\/span> rating <= 5<\/span>\nORDER<\/span> BY<\/span> \n    title;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the result set:<\/p>\n\n\n\n
\"db2<\/figure>\n\n\n\n
2) Using multiple Db2 AND operators example<\/h3>\n\n\n\n
This example uses two AND<\/code> operators to find books whose ratings are between 4 and 5 and the number of pages is greater than 1300:<\/p>\n\n\n
SELECT<\/span>    \n    title, \n    rating, \n    total_pages\nFROM<\/span>    \n    books\nWHERE<\/span> rating >= 4<\/span>\n        AND<\/span> rating <= 5<\/span> AND<\/span> total_pages > 1300<\/span>\nORDER<\/span> BY<\/span> \n    title;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output is as follows:<\/p>\n\n\n\n
\"db2<\/figure>\n\n\n\n
3) Using Db2 AND operator with parentheses<\/h3>\n\n\n\n
If you use the AND<\/code> and OR<\/code> operators with more than two conditions, you can use parentheses to explicitly specify the order in which you want Db2 to evaluate the conditions.<\/p>\n\n\n\n
This example uses both AND<\/code> and OR<\/code> operators to find books that satisfy both the following conditions:<\/p>\n\n\n\n