PostgreSQL OR
To filter the results, the PostgreSQL OR condition is used with SELECT, INSERT, UPDATE and DELETE statements to satisfy either of the conditions.
Syntax:
WHERE condition_1 OR condition_2 OR condition_3 …. OR condition_n;
Parameters:
condition_1, condition_2… condition_n: They are used to specify the conditions to be strictly followed for selection.
Example:
Students table:
ID | NAME | AGE |
1 | Joy | 5 |
2 | Smiley | 13 |
3 | Happy | 11 |
4 | Tom | 15 |
5 | Jerry | 10 |
6 | Bruno | 6 |
7 | David | 8 |
Query:
SELECT * FROM “STUDENTS” WHERE “AGE” = 10 OR “AGE” = 15 ORDER BY “NAME”; |
Output:
ID | NAME | AGE |
5 | Jerry | 10 |
4 | Tom | 15 |