• Below is a selection from the wikitechytable table used in the examples:

• The AND operator displays a record if all the conditions are TRUE.
• The OR operator displays a record if any of the conditions are TRUE.

SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;

SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR condition3 ...;

• The WHERE clause can contain one or many AND operators.

SELECT * FROM wikitechytable WHERE gender = 'male' AND fees <= 50

• The WHERE clause can contain one or many OR operators.

SELECT * FROM wikitechytable WHERE gender = 'Other' OR fees <= 50

• You can combine the AND and OR operators.

SELECT * FROM wikitechytable WHERE gender = 'female' AND (fees = 0 OR course = 'Flutter')