postgresHow to use AND / OR operators
SELECT * FROM person WHERE gender = 'Female' AND (country_of_birth = 'CA' OR country_of_birth = 'US');ctrl + cSELECT * FROM personselect all columns from table | WHEREfilter the results by a condition |
gender = 'FEMALE'first condition | country_of_birth = 'CA'second condition |
country_of_birth = 'US'third condition | ANDtests both first and second conditions |
ORtests both (first and second conditions) or third condition | |
More of Postgres
- How to select unique (distinct) values from column
- Create Table
- How to group resulting set by specific column values
- How to use aliases
- How to filter resulting set after grouping is done
- Order By
- How to select column which value is between two values
- Where
- How to filter column based on multiple values
See more codes...