A select statement in SQL may contain one or more conditions (also known as predicates) in the where clause. A condition evaluates to true or false or unknown. The where clause must return a true value for a particular row to be selected.
To learn how to check multiple conditions in a SQL select statement, follow these steps:
orkeyword. Either condition can be true in order for the row to be selected.
andkeyword. Both conditions must be true in order for the row to be selected.