Comparison Operators

Purpose: Used to compare two values, returning a boolean result (TRUE, FALSE, or NULL).Operators:

• =: Equal
• != or <>: Not equal
• >: Greater than
• <: Less than
• >=: Greater than or equal to
• <=: Less than or equal to

Example:

SELECT * FROM employees WHERE salary >= 50000;

Explanation: This retrieves employees whose salary is 50,000 or more.