-
SQLite Tutorial
- sqlite-tutorial
- sql-vs-sqlite
- sqlite-history
- sqlite-features
- sqlite-advantages
- sqlite-installation
- sqlite-commands
- sqlite-syntax
- sqlite-data-types
- sqlite-operators
- sqlite-expressions
Databases
Table
CRUD Operation
Clauses/Conditions
- sqlite-where
- sqlite-and
- sqlite-or
- sqlite-like
- sqlite-glob
- sqlite-limit
- sqlite-order-by
- sqlite-group-by
- sqlite-having
- sqlite-distinct
- sqlite-union
- sqlite-union-all
SQLite Joins
SQLite Date & Time
- sqlite-date-and-time
- sqlite-date()
- sqlite-datetime()
- sqlite-juliandday()
- sqlite-now()
- sqlite-strftime()
- sqlite-time()
Aggregate Functions
SQLite Triggers
SQLite Keys
SQLite Import/Export
Connectivity
Interview Questions
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
|