SQL -Structured Query Language - Sql Clause - And Operator Tutorial

To use two or more conditions to retrieve, insert, update and delete records from the existing created table. And from this, every condition has to meet. Then we can use a ' WHERE ' statement with AND conditions.

Syntax-

The basic syntax of WHERE statement with AND conditions.–

SELECT * FROM table_name WHERE condition_1 AND condition_2;

In this, both condition_1 and condition_2 will be met.

For example –

SELECT * FROM employees WHERE first_name LIKE 'su%' AND employee_id>150;

Run Query

In this statement, it will retrieve the first_name start with specific syntax “su” and employee_id is greater than 150 from the table employees.

In this, both conditions (first_name LIKE “su%”) and (employee_id>150) will be met.

Note- AND Condition not only used in SELECT but also INSERT, UPDATE and DELETE.