What is the AND operator

Question

Hi!!

Can someone tell me what is the AND operator?

Comments

The AND operator is a Boolean operator used to perform a logical conjunction on two expressions -- 

Expression 1 And Experession 2. AND operator returns a value of TRUE if both its oprands are TRUE, and otherwise FALSE 

Hope you got your answer its very simple term on which we can perform multiple operation.

---

Thank you @psharma. It is a simple yet important operation.

---

Hello @psharma. Thanks for your explanation. Could you please post this as an answer? It would be much more visible and helpful then. Thank you.

Answer 1

The AND operator is used to filter records that rely on more than one condition. This operator displays the records, which satisfy all the conditions separated by AND, and give the output TRUE.

Syntax:

SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;