SQLite AND & OR Operators

Here we will learn sqlite and, or operators with example and how to use sqlite and operators, sqlite or operators and sqlite and & or operators in sqlite select or insert or update or delete statements with example

SQLite AND & OR Operators

In SQLite AND & OR operators are used to perform multiple conditions on select, insert, update and delete statements based on our requirements.

 

We will learn how to use SQLite AND Operator, SQLite OR Operator and SQLite AND and OR operators in detailed with examples.

SQLite AND Operator

In SQLite AND operator will return rows or records which satisfy the conditions defined by using AND operator. Generally, we use SQLite AND operator to define multiple conditions in where clause.

Syntax of SQLite AND Operator

Following is the syntax of SQLite AND operator to get records which satisfy conditions defined in select or insert or update or delete statements.

 

In above sqlite and operator syntax it will return records once all defined conditions become true.

SQLite AND Operator Example

We will see how to use SQLite AND operator with example before that first create emp_master table and insert some data to perform operations by using the following queries.

 

Now run the following query to check records of emp_master table.

 

Now write SQLite Query to use AND operator with select statement to get rows from emp_master table based on our conditions.

 

Here it will fetch all the records of emp_master table whose last name is patel and salary is greater than 1000 like as shown below.

 

This is how we can use SQLite AND condition to get records or rows based on our requirements.

SQLite OR Operator

The SQLite OR condition is useful to define multiple conditions in SQLite statements and it will return rows or records from the statement if any of one condition satisfied.

Syntax of SQLite OR Operator

Following is the syntax of SQLite OR operator to return records even if one condition is satisfied.

 

In the above SQLite OR operator syntax, we defined multiple conditions with OR operator. In this if all the defined conditions satisfied means it will return records based on all conditions otherwise if anyone condition satisfies also it will return records based on that condition alone.

SQLite OR Operator Example

Following is the example SQLite OR Operator with Select statement to get records or rows from a table based on the defined conditions.

 

Here it will fetch all the records of emp_master table whose last name is patel or whose salary is greater than 15000 like as shown below.

 

SQLite AND and OR Operators

In SQLite we can use both AND and OR operators together in SELECT, INSERT, UPDATE, or DELETE statement to perform required operations.

 

When combining AND and OR operators in SQLite, it is important to use parentheses so that the database knows what order to evaluate each condition.

Syntax of SQLite AND & OR Operators

Following is the syntax of using SQLite AND & OR together.

 

If you observe above SQLite statement, we defined few properties those are

 

condition1, condition2, ... condition_n - All of the conditions that must be met for the records to be selected.

 

If we use AND & OR operators together in SQLite, then

 

• The SQLite AND & OR conditions allow us to test multiple conditions.
• Don't forget the order of operation parentheses!

Example of SQLite AND and OR Operators

Following is the example of using both SQLite AND and OR operators in a select statement.

 

If you observe SQLite AND & OR example we defined AND & OR conditions by separating parentheses and it will return all the employees whose is having a last_name as 'Patel' and a first_name as 'Yamini', and all the employees who are having an emp_id greater than 5.

 

This is how we can use SQLite AND and OR operator with SQLite statements to get the required data based on our conditions.