SQL Query Operators | Arithmetic, Comparison & Logical Operators

Summary: In this tutorial, We’re going to cover what exactly SQL query operators (SQL Operators) are, before providing a comprehensive list of the different types with full examples for each.

Introduction Of SQL Query Operators

An SQL Query Operators are used mainly in an SQL Server statement’s WHERE clause to perform an operation(s), like comparisons, Arithmetic, & logical operations. this operator is a reserved character, which is used for the purpose of specifying the conditions during an SQL statement and to serve as conjunctions for multiple conditions in a statement.

• Arithmetic operators
• Comparison operators
• Logical operators
• Operators used to negate conditions

A) SQL Arithmetic Operators

Assume that ‘variable a’ holds 100 and ‘variable b’ holds 200, then −

Example:-

SELECT 100 + 200;
SELECT 100 - 200;
SELECT 100 * 200;
SELECT 200 / 100;
SELECT 200 % 100;

Output:

B) SQL Comparison Operators

Assume that ‘variable a’ holds 100 and ‘variable b’ holds 200, then −

Demo Table: Students

Let’s see to better understanding the example, Here, i will consider the following given below table to perform various operations.

Example:

Example[Use equal to]:

SELECT * FROM Students
WHERE Age = 28;

Output:

Example[Use greater than]:

SELECT * FROM Students
WHERE Age > 30;

Output:

Example[Use Less than]:

SELECT * FROM Students
WHERE Age < 29;

Output:

Example[Use less than or equal to]:

SELECT * FROM Students
WHERE Age <= 29;

Output:

Example[Not equal to]:

SELECT * FROM Students
WHERE Age != 30;

Output:

C) SQL Logical Operators

Here is a list of all the logical operators which are available in SQL Server.

Example:

To see the demonstration, I will consider the Students’ table considered above, to perform the Logical Operators operations.

Example[ANY]

SELECT * FROM Students
WHERE Age > ANY (SELECT Age FROM Students WHERE Age > 29);

Output:

Example[BETWEEN & AND]

SELECT * FROM Students
WHERE Age BETWEEN 28 AND 30;

Output:

Example[IN]

SELECT * FROM Students
WHERE Age IN('28', '30');

Output:

SQL Query Operators: Conclusion

In this article, You have learned SQL Query Operators (SQL Operators). Here, I have explained only a few demonstrations. I would say, that go ahead & practice for more examples on the different types of operators to get good practice on writing SQL queries.