List of Operators In SQL [With Examples]

As there are several types of operators in SQL  anyone can take any SQL course to learn more operators. Let us understand them with examples in the next section.

Operators in SQL

1. Arithmetic Operators

Arithmetic operators can be used to perform arithmetic operations that include addition, subtraction, multiplication, and division.

Check out upGrad’s Advanced Certification in Cyber Security

  Operator

Example of Arithmetic Operators in SQL:

SELECT 80 + 10;

SELECT 80 – 10;

SELECT 80 * 10;

SELECT 80 / 10;

SELECT 80 % 10;

The output of the above SQL commands with arithmetic operators will be:

90

70

800

8

0

So, these are the arithmetic operators of SQL. Let us now see the Comparison operators in SQL.

2. Comparison Operators in SQL

Comparison operators are used to comparing the two values that may be either less than or greater than or equal to each other. The table of comparison operators is:

To compare the logical values, these operators are used in SQL. Now let us discuss a few of the 

logical operators in SQL.

Example of “=”,”<” and “>” Operator

SELECT * FROM Employees WHERE Age = 20;

SELECT * FROM Employees WHERE Age < 20;

SELECT * FROM Employees WHERE Age > 20;

upGrad’s Exclusive Software Development Webinar for you –

SAAS Business – What is So Different?

3. Logical Operators in SQL

Let us now discuss the logical operators in SQL. There are few cases as specified in the following table where we can use these logical operators:

Example of BETWEEN and IN Operators

SELECT * FROM Employees WHERE Age BETWEEN 20 AND 40;

SELECT * FROM Employees WHERE Age IN (‘20’,‘ 40’);

These two queries are examples of SQL operators.

Related Read: SQL Project Ideas & Topics

Learn Software Development Courses online from the World’s top Universities. Earn Executive PG Programs, Advanced Certificate Programs, or Masters Programs to fast-track your career.

Conclusion

SQL has many uses and operators, and you can use and practice these operators to know more about them. SQL operators help in fast data processing. Moreover, to compare any two values, these operators can be directly used. The operators are being asked during many interviews of fresher and experienced candidates. Learning SQL commands and an operator can help you in clearing interviews.

If you’re interested to learn more about full-stack development, check out upGrad & IIIT-B’s Executive PG Programme in Full-stack Software Development which is designed for working professionals and offers 500+ hours of rigorous training, 9+ projects, and assignments, IIIT-B Alumni status, practical hands-on capstone projects & job assistance with top firms.