Javatpoint Logo
Javatpoint Logo

SQLite AND Operator

The SQLite AND Operator is generally used with SELECT, UPDATE and DELETE statement to combine multiple conditions. It is a conjunctive operator which makes multiple comparisons with different operators in the same SQLite statement.

It is always used with WHERE Clause.

Syntax:

Example:

We have a table named 'STUDENT' having following data:

Sqlite And operator 1

Select all students from the table 'STUDENT' where AGE is greater than or equal to 25 AND fees is greater than or equal to 20000.00

Output:

Sqlite And operator 2
Next TopicSQLite Or Clause




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA