My 2 Cents The Logical Operators

Swati Mishra

Content Writer
Multiple search condition can be combined by using logical operators. These are three logical operators are using in the database.
AND: when all condition true
OR: when any condition true
NOT: Neutralizes the expression
Syntax

SELECT column_List
FROM table_name
WHERE conditional_exporession{ AND/OR/NOT} conditional_expression
 

Manish Mishra

Content Writer
the logical operator uses three expressions And, Or and Not that defines as; And to join to or more column together, Or to one of two or more table and Not defines the neither of any, respectively.
 

Swati Mishra

Content Writer
These all three (AND/OR/ NOT) have their own reason to use in different places. If any condition will satisfy then it shows the result according to match with this operator
 
Top