YouTip

# PostgreSQL AND & OR Operators In PostgreSQL, AND and OR are also called logical operators. They are used to narrow down the query scope when querying data. We can specify one or more query conditions using AND or OR. ### AND The AND operator indicates that one or more conditions must all be true. The syntax for using AND in the WHERE clause is as follows: SELECT column1, column2, columnN FROM table_name WHERE AND ...AND ; ### Example Create the COMPANY table ((https://static.jyshare.com/download/company.sql) ), with the following data: tutorialdb# select * from COMPANY; id | name | age | address | salary ----+-------+-----+-----------+-------- 1 | Paul | 32 | California| 20000 2 | Allen | 25 | Texas | 15000 3 | Teddy | 23 | Norway | 20000 4 | Mark | 25 | Rich-Mond | 65000 5 | David | 27 | Texas | 85000 6 | Kim | 22 | South-Hall| 45000 7 | James | 24 | Houston | 10000(7 rows) The following example reads all records where the AGE field is greater than 25 and the SALARY field is greater than or equal to 65000: tutorialdb=# SELECT * FROM COMPANY WHERE AGE >= 25 AND SALARY >= 65000; id | name | age | address | salary ----+-------+-----+------------+-------- 4 | Mark | 25 | Rich-Mond | 65000 5 | David | 27 | Texas | 85000(2 rows) ### OR The OR operator indicates that only one of multiple conditions needs to be satisfied. The syntax for using OR in the WHERE clause is as follows: SELECT column1, column2, columnN FROM table_name WHERE OR ...OR Create the COMPANY table ((https://static.jyshare.com/download/company.sql) ), with the following data: tutorialdb# select * from COMPANY; id | name | age | address | salary ----+-------+-----+-----------+-------- 1 | Paul | 32 | California| 20000 2 | Allen | 25 | Texas | 15000 3 | Teddy | 23 | Norway | 20000 4 | Mark | 25 | Rich-Mond | 65000 5 | David | 27 | Texas | 85000 6 | Kim | 22 | South-Hall| 45000 7 | James | 24 | Houston | 10000(7 rows) The following example reads all records where the AGE field is greater than or equal to 25 or the SALARY field is greater than or equal to 65000: tutorialdb=# SELECT * FROM COMPANY WHERE AGE >= 25 OR SALARY >= 65000; id | name | age | address | salary ----+-------+-----+------------+-------- 1 | Paul | 32 | California | 20000 2 | Allen | 25 | Texas | 15000 4 | Mark | 25 | Rich-Mond | 65000 5 | David | 27 | Texas | 85000(4 rows)