AND Condition


SQLite: AND Condition

This SQLite tutorial explains how to use the SQLite AND condition with syntax and examples.


The SQLite AND Condition (also called the AND Operator) is used to test two or more conditions in a SELECT, INSERT, UPDATE, or DELETE statement.




Parameters or Arguments:

condition1, condition2, … condition_n

All of the conditions that must be met for the records to be selected.

Note: The SQLite AND condition allows you to test 2 or more conditions. The SQLite AND condition requires that all of the conditions (ie: condition1, condition2, condition_n) be must be met for the record to be included in the result set.


The following SQLite statement selects all the employee’s from the Position “developer” and the hire_date “2014-01-01”, in the “Employee” table:

id name position hire_date
100 chiru developer 1/1/2014
104 jaya developer 1/1/2014