Learn SQL AND clause to add one or more conditions. Display result when all condition is true with SQL AND clause in select, insert, update and delete query.
The AND clause is data manipulation language which can be used to manipulate the record only when all the specified condition is true. It can be useful when you need many useful rules and when all the rule is true, you will get the required result from the table.
You can use the AND clause with SELECT, INSERT, UPDATE AND DELETE statements.
How to Use SQL AND Clause with WHERE Clause to Filter Result Based on All Condition True
The syntax to use the SQL AND clause with above useful statements is given below. You have to use more than one condition in WHERE clause. However, it’s not necessary to use a conditional statement in the query.
Syntax1: AND Clause with SELECT Statement
|
1 2 3 |
SELECT column_name FROM tablename WHERE condition1 AND condition2; |
The above syntax contains the SELECT statement with the single column and two conditions with AND clause. In addition to this, you can put more than one column with comma separation and more than two conditions with AND clause in them.
Syntax2: AND Clause with UPDATE Statement
|
1 2 3 |
UPDATE column_name SET column_name = new value WHERE condition1 AND condition2; |
Update the value of a column with the syntax given above. You can specify more than one condition to update the exact value in the table. The table will not get updated If all the condition is not true. If you do not specify the condition, the query will update all the values in the specified column.
Syntax3: AND Clause with DELETE Statement
|
1 2 3 |
DELETE FROM tablename WHERE condition1 AND condition2; |
Delete the exact record from the table using more than one condition. The above syntax deletes the rows from the table only when all the specified condition is true. If you do not specify any condition in the WHERE clause, the above syntax will delete all the records of a table.
Parameter Descriptions
| Sr.No | Parameter Name | Description |
|---|---|---|
| 1 | column_name | Enter the column names to which you want to apply the multiple WHERE condition and display the rows only when all the conditions are true. You can also use the symbol (*) to apply more than a condition to all the columns of a table. In addition to this, multiple columns can be added with comma(,) separation. |
| 2 | tablename | Specify the name of the table to which you want to apply the multiple conditions. |
| 3 | condition1 | Specify the first condition with the operator, columns, and values to filter the exact rows. |
| 4 | condition2 | Specify the second condition with the operator, columns, and values to apply in the WHERE clause. |
|
1 2 3 |
SELECT Name FROM Customers WHERE Salary>20000 AND Designation='Project Consultant'; |
|
1 2 3 |
UPDATE Customers set Designation='Senior Project Consultant' WHERE Salary>20000 AND Designation='Project Consultant'; |
|
1 2 3 |
DELETE FROM Customers WHERE Salary>50000 AND Designation='Project Consultant'; |
You must also learn.
Reference