Essential Books

Selecting with more than 1 condition.

suggest change

The AND keyword is used to add more conditions to the query.

Name | Age | Gender | —— | —— | —— | Sam | 18 | M | John | 21 | M | Bob | 22 | M | Mary | 23 | F | 

SELECT name FROM persons WHERE gender = 'M' AND age > 20;

This will return:

Name | —— | John | Bob |

using OR keyword 

SELECT name FROM persons WHERE gender = 'M' OR age < 20;

This will return:

name | —–| Sam | John | Bob |

These keywords can be combined to allow for more complex criteria combinations: 

SELECT name
FROM persons
WHERE (gender = 'M' AND age < 20)
   OR (gender = 'F' AND age > 20);

This will return:

name | —–| Sam | Mary |

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
* SELECT
* Using the wildcard character to select all columns in a query.
* SELECT Using Column Aliases
* Select Individual Columns
* Selecting specified number of records
* Selecting with Condition
* Selecting with CASE
* Select columns which are named after reserved keywords
* Selecting with table alias
* Selecting with more than 1 condition.
* Selecting with Aggregate functions
* Get aggregated result for row groups
* Selection with sorted Results
* Selecting without Locking the table
* Select with condition of multiple values from column
* Select distinct unique values only
* Selecting with null
* Select rows from multiple tables
Table Of Contents