How to use Operators in Select statement in sql query | #selectstatement #sql #sqlquery #operators

The #SQL #AND, #OR and #NOT Operators
The #WHERE clause can be combined with AND, OR, and NOT #operators.

The AND and OR operators are used to filter records based on more than one condition:

The AND operator displays a record if all the conditions separated by AND are TRUE.
The OR operator displays a record if any of the conditions separated by OR is TRUE.
The NOT operator displays a record if the condition(s) is NOT TRUE.