AND Condition


 

SQLite: AND Condition

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

 

Description:
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.

 

Syntax:

 

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.

 

Examples:
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