There are various comparison operators used in it such as =,>, <,!, ! =, etc. Comparison operator allow row retrieval from a table based on the condition specified in the WHERE clause
Syntax
SELECT column_list
FROM table_name
WHERE expression1 comparison_operator expression2