SQL Server Comparison Operators

SQL Server Comparison Operators

Comparison operators can be used to specify the condition in the SQL query.

Comparison operators are used to retrieve the rows from a database table based on condition specified in the WHERE clause.

SQL Server supports the following comparison operators to specify condition in SQL.

Employee Table

Let us consider the example 'Employee' database table.

Equal to (=) operator

Checks whether left and right side values are equal or not.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId = 1

Less than (<) operator

Checks whether left side is less than right side value.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId < 2

Greater than (<) operator

Checks whether left side is greater than right side value.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId > 1

Less than or equal to (<=) operator

Checks whether left side is less than or equal to right side value.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId <= 2

Greater than or equal to (>=) operator

Checks whether left side is greater than or equal to right side value.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId >= 1

Not equal to (<>, !=) operator

Checks whether left side is less than right side value.

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId != 2

SELECT Name, City, Email, Salary
FROM Employee
WHERE DeptId <> 2