When three or more and and or conditions are combined, it is easier to use the sql keyword(s): not in only. in only. both in and not in. like only?
Answers
Answered by
1
The answer is both IN and NOT IN.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s) both IN and NOT IN.
The SQL IN condition/operator makes it easy to verify if an expression matches a value among a given set of values. It helps in reducing the number of AND or OR conditions in a SELECT, INSERT, DELETE or UPDATE statement.
The SQL NOT IN condition/or operator performs the reverse function of the IN operator.
Similar questions