Which operator is used to filter and display rows when all two or more conditions are satisfied?
Answers
Answered by
1
AND Operator is used in SQL statements, to filter and display rows when all conditions are satisfied.
Explanation:
- Operators are reserved keywords or characters that are used for performing comparisons and arithmetic operations in SQL statements. These are used in WHERE clause, to specify single or multiple filter conditions.
- Some of the different types of operators used in SQL statements are : Arithmetic Operators, Comparison Operators, Logical Operators and Operator used to negate conditions.
- AND is a logical Operator that allows the programmers to specify multiple conditions in WHERE clause. The rows thus, returned are filtered on multiple conditions being true.
To know more about SQL operators, visit:
https://brainly.in/question/7060611
Similar questions