AND condition in SQLite

SQLite AND To make multiple comparisons with different operators in the same statement, the SQLite AND Operator are used. It is generally used with SELECT, UPDATE and DELETE statements. It is a conjunctive operator and is always used with the WHERE Clause.

Syntax:

SELECT column_1, column_2, column_N   
FROM table_name  
WHERE condition_1 AND condition_2...AND condition_N;   

Example: TEACHERS Table:

SELECT * FROM TEACHERS
WHERE ID > 2 AND AGE >= 30;

Output:

Explanation: The “TEACHERS” is an already existing table. Here we are selecting those rows of the table where the value in the ID column is greater than 2 and the value in the AGE column is greater than or equal to 30.

Please follow and like us: