And Clause
The And Clause is used to join or create two or more conditions to be met.
It is used in SQL statement like SELECT,INSERT,UPDATE and DELETE statements.
Syntax:
SELECT columns1, coloumn2,coloumn3,...coloumnN
FROM table_name
WHERE condition 1
AND condition 2
AND condition3...
AND conditionN;
Example:
Teacher
| c_id |
c_name |
c_age |
c_experience |
| 01 |
Baithy |
37 |
7 |
| 02 |
Lennin |
27 |
2 |
| 03 |
Shaun |
41 |
6 |
| 04 |
Peter |
29 |
3 |
| 05 |
Mike |
44 |
8 |
SELECT * from Teacher
WHERE age>30 AND experience>5;
It would produce the following output:
| c_id |
c_name |
c_age |
c_experience |
| 01 |
Baithy |
37 |
7 |
| 03 |
Shaun |
41 |
6 |
| 05 |
Mike |
44 |
8 |
