SQLite And Clause

by Online Tutorials Library July 14, 2022

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:

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

Example:

We have a table named ‘STUDENT’ having following data:

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:

Next TopicSQLite Or Clause

SQLite And Clause

SQLite AND Operator

SUM Function in SQL

Event Listener

You may also like