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
1 SQLite WHERE Clause
2 SQLite AND Operator

3 SQLite OR Operator
4 SQLite LIKE Clause (Operator)
5 SQLite GLOB Clause (Operator)
6 SQLite LIMIT Clause
7 SQLite ORDER BY Clause
8 SQLite GROUP BY Clause
9 SQLite HAVING Clause
10 SQLite DISTINCT Clause
11 SQLite Union Operator
12 SQLite Union All Operator
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Try it
http://codeamaze.com
Contents +