SQL Comparison Operators

SQL Comparison operator is used to compare the two operands or two data values present in the database tables.
The comparison operators can also compare one expression to the other.
The SQL comparison operators are used with the WHERE clause.

The various SQL comparison operators are:

Operator	Description
=	The Equal operator is used to show data that matches with the provided value in the query.
>	The Greater Than is used to show data that are greater than the provided value in the query.
<	The Lesser Than is used to show data that are lesser than the provided value in the query.
>=	The Greater Than Equals to an operator is used to show data that are greater than and equal to the provided value
<=	The Lesser Than Equals to an operator is used to show data that are lesser than and equal to the provided value
!=	The Not Equal operator is used to show data that do not match with the provided value in the query

Example:

Suppose we have a database of students. The student table has 4 columns namely student ID, Name, physics(marks in physics), and Chemistry(marks in chemistry)

ID	Name	Physics	Chemistry
1	Aman	86	92
2	Sushant	91	91
3	Soumya	98	98

Let us perform some comparison operations using comparison operators:

SELECT *
FROM student
WHERE physics = 86;

Output:

ID	Name	Physics	Chemistry
1	Aman	86	92

In this example, we fetch the student detail whose physics mark is 86