SQL Operators

• SQL operators are keywords used to perform data operations in a relational database. 

Types of SQL Operators

1. SQL Arithmetic Operators.
2. SQL Comparison Operators.
3. SQL Logical Operators.
4. SQL Set Operators.
5. SQL Unary operators.
6. SQL Bitwise Operators.

Arithmetic operators :

• The SQL Arithmetic Operator performs arithmetic computations and operations on the two operands or the numerical data in the database tables.

Example:

Let us consider student tables having 3 columns namely student ID, Physics(marks in physics), and Chemistry(marks in Chemistry):

Now, let us perform some arithmetic operations using arithmetic operators.

SELECT Physics + Chemistry as Total _Marks 
FROM student;

Output:

Total_ Marks
178
176
171

• In this query, we have added the Physics and Chemistry marks as the total marks.