Comparison Operators are used to fetch the rows or values which satisfies the specified condition in the WHERE clause. There are various Comparison operators are used in WHERE clause are listed as follows –

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

Scenario – Fetch list of matching rows by using Equal to(=) operator.

Requirement – Fetch all employees whose manager id is Employee3. The query was as follows –

SELECT * FROM employee_ details WHERE manager_id = "Employee3"; 

By executing above query, we can get results as shown below –

Scenario – Fetch list of matching rows by using Not Equal to(<>) operator.

Requirement – Fetch employee details other than the directors. The query was as follows –

SELECT * FROM employee_ details WHERE designation != "Director";  

It can also written as follows –

SELECT * FROM employee_details WHERE designation <> "Director"; 

By executing above query, we can get results as shown below –

Scenario – Fetch list of matching rows by using Greater than(>) operator.

Requirement – Fetch employee details whose salary > 20000. The query was as follows -

SELECT * FROM employee_details WHERE salary > 20000; 

By executing above query, we can get results as shown below –

Scenario – Fetch list of matching rows by using Greater than or equal to (>=) operator.

Requirement – Fetch employee details whose salary >= 20000. The query was as follows –

SELECT * FROM employee_details WHERE salary >= 20000; 

By executing above query, we can get results as shown below –

Scenario – Fetch list of matching rows by using Less than (<) operator.

Requirement – Fetch employee details whose salary less than 25000. The query was as follows –

 SELECT * FROM employee_details WHERE salary < 25000; 

By executing above query, we can get results as shown below –

Scenario – Fetch list of matching rows by using Less than or equal to (<=) operator.

Requirement6 –Fetch all employees details whose salary less than or equal to 25000.The query was as follows –

SELECT * FROM Employee WHERE salary < = 25000; 

By executing above query, we can get results as shown below –