SQL Comparison Operators

The SQL Comparison Operators will be very useful to compare the Column values with the valid Expression. Following table shows the list of available comparison operators in SQL Server.

SQL Comparison Operators	Description
=	Equal to
>	Greater than
<	Less than
>=	Greater than or Equal to
<=	Less than or Equal to
<>	NOT Equal to
!=	Not Equal to
!>	Not Greater than
!<	Not Less than

In this article we will show you, How to use these comparison Operators in SQL Server 2014 with examples. For this, We are going to use the below shown data

SQL Comparison Operators Examples

SQL = Operator (Equal to)

Equals Operator will display the records whose column value is exactly equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose Occupation is exactly equal to Management

-- SQL Server Comparison Operators Example
SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [Occupation] = 'Management'

OUTPUT

SQL > Operator (Greater than)

Greater than Operator will display the records whose column value is Greater than the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Greater than 60000

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] > 60000

OUTPUT

SQL < Operator (Less than)

Less than Operator will display the records whose column value is Less than the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Less than 70000

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] < 70000

OUTPUT

SQL >= Operator (Greater than Or Equal to)

Greater than or Equal to Operator will display the records whose column value is greater than or equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Greater than or equal to 60000

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] >= 60000

OUTPUT

SQL <= Operator (Less than Or Equal)

Less than or Equal to Operator will display the records whose column value is Less than or equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Less than or equal to 70000

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] <= 70000

OUTPUT

SQL <> Operator (Not Equal to)

SQL Not Equal to Operator will display the records whose column value is Not equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Not Equal to 60000. It means, it will display all the records expect [Yearly Income] is Equal to 60000

-- SQL Server Comparison Operators Example
SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] <> 60000

OUTPUT

SQL != Operator (Not Equal to)

This is same as <> Operator. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Not Equal to 60000.

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] != 60000

OUTPUT

SQL !< Operator (Not Less than)

SQL Not Less than Operator will display the records whose column value is Greater than or Equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Not Less than 70000. It means, it will display all the records whose [Yearly Income] is greater than or equal to 70000

-- SQL Server Comparison Operators Example
SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] !< 70000

OUTPUT

SQL !> Operator (Not Greater Than)

Not Greater than Operator will display the records whose column value is Less than or Equal to the given expression. For example, The following query will find all the Customers present in the Customers table whose [Yearly Income] is Not Greater than 70000. It means, it will display all the records whose [Yearly Income] is less than or equal to 70000

SELECT [FirstName]
      ,[LastName]
      ,[YearlyIncome]
      ,[Education]
      ,[Occupation]
 FROM [Customer]
 WHERE [YearlyIncome] !> 70000

OUTPUT

Thank You for Visiting Our Blog