Question

What is the usage of AND & OR operators with WHERE clause?

Answer 1

AND & OR operators are used with WHERE clause to combine two or more than two conditions together.

Syntax:

SELECT column1, column2, columnN     

FROM table_name    

WHERE [condition1] AND [condition2]...OR [conditionN];