SQL AND

The SQL AND condition is used in SQL query to create two or more conditions to be met.

It is used in SQL SELECT, INSERT, UPDATE and DELETE statements.

Let's see the syntax for SQL AND:

SELECT columns
FROM tables
WHERE condition 1
AND condition 2;

The SQL AND condition requires that both conditions should be met.

The SQL AND condition also can be used to join multiple tables in a SQL statement.

SQL "AND" example with "INSERT" statement

This is how an SQL "AND" condition can be used in the SQL INSERT statement.

For example:

INSERT INTO suppliers
(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE customer_name ='IBM'
AND employees =1000;

This is how the "AND" condition can be used in the SQL UPDATE statement.

For example:

UPDATE suppliers
SET supplier_name = 'HP'
WHERE supplier_name = 'IBM'
AND offices = 8;

This is how an SQL "AND" condition can be used in the SQL DELETE statement.

For example:

DELETE FROM suppliers
WHERE supplier_name = 'IBM'
AND product = 'PC computers';

Next TopicSQL OR