Comparison operators in SQL are used to compare two values and determine if they meet specific criteria. These operators are essential for filtering data in SQL queries, especially within the WHERE clause. Here are the primary comparison operators in SQL:

Equal to (=) Operator

The equal to operator checks if the values of two operands are equal. It returns true if they are equal, otherwise false. For example:

This query retrieves all employees whose last name is 'Himuro'¹.

Not Equal to (<>) Operator

The not equal to operator checks if the values of two operands are not equal. It returns true if they are not equal, otherwise false. For example:

This query retrieves all employees whose department ID is not 8¹.

Greater than (>) Operator