SQLite AND OperatorThe 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: 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
|