Comparison and Logical Operators in SQL

Comparison Operators

Logical Operators

-- AND: both must be true
SELECT * FROM students WHERE class='10' AND marks>=60;

-- OR: at least one true
SELECT * FROM students WHERE city='Delhi' OR city='Agra';

-- NOT: reverse
SELECT * FROM students WHERE NOT class='10';

Summary

• Comparison: =, !=, >, <, >=, <=.
• Logical: AND (both), OR (either), NOT (reverse).

Comparison Operators

Logical Operators

-- AND: दोनों true हों
SELECT * FROM students WHERE class='10' AND marks>=60;

-- OR: कम से कम एक true
SELECT * FROM students WHERE city='Delhi' OR city='Agra';

-- NOT: उल्टा
SELECT * FROM students WHERE NOT class='10';

सारांश

• Comparison: =, !=, >, <, >=, <=।
• Logical: AND (दोनों), OR (कोई एक), NOT (उल्टा)।