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:

snippet
SELECT column1, column2, columnN 
FROM table_name
WHERE [condition1] AND [condition2]...AND [conditionN];

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

snippet
SELECT * FROM STUDENT WHERE AGE >= 25 AND FEES >= 15000;

Output:

Sqlite And operator 2
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents