SQL ARITHMETIC OPERATORS:-

The SQL reserved words and characters are called operators,

SQL operators are important in database management systems (DBMS) as they allow us to
manipulate and retrieve data efficiently.

SQL operators are symbols or keywords used to perform operations on data in SQL queries.

These operations can include mathematical calculations, data comparisons, logical

manipulations, other data-processing tasks.

Operators help in filtering, calculating, and updating data in databases, making them crucial
for query optimization and accurate data management.--In SQL, an operator can either be a
unary or binary operator.

The unary operator uses only one operand for performing the unary operation, whereas the
binary operator uses two operands for performing the binary operation.

Types of Operator

SQL operators are categorized in the following categories:

1. SQL Arithmetic Operators

2.SQL Logical Operators

2. SQL Set Operators

3. SQL Bit-wise Operators
4. SQL Unary Operators

SQL Arithmetic Operators

The Arithmetic Operators perform the mathematical operation on the numerical data of the
SQL tables. These operators perform addition, subtraction, multiplication, and division
operations on the numerical operands.

Following are the various arithmetic operators performed on the SQL data:

1. SQL Addition Operator (+)

2. SQL Subtraction Operator (-)
3. SQL Multiplication Operator (+)
4. SQL Division Operator (-)
5. SQL Modulus Operator (+)
 SQL Addition Operator (+)
The Addition Operator in SQL performs the addition on the numerical data of the database
table. In SQL, we can easily add the numerical values of two columns of the same table by
specifying both the column names as the first and second operand. We can also add the numbers
to the existing numbers of the specific column.

Syntax of SQL Addition Operator:

1. SELECT operand1 + operand2;

Employee_details table, which has four columns Emp_Id, Emp_Name, Emp_Salary, and
Emp_Monthlybonus.

101 Tushar 25000 4000

102 Anuj 30000 200

o Suppose, we want to add 20,000 to the salary of each employee specified in the table.
Then, we have to write the following query in the SQL:
1. SELECT Emp_Salary + 20000 as Emp_New_Salary FROM Employee_details;

In this query, we have performed the SQL addition operation on the single column of the given
table.

o Suppose, we want to add the Salary and monthly bonus columns of the above table, then
we have to write the following query in SQL:
SELECT Emp_Salary + Emp_Monthlybonus as Emp_Total_Salary FROM Employee_details;

SQL Subtraction Operator (-)

The Subtraction Operator in SQL performs the subtraction on the numerical data of the database
table. In SQL, we can easily subtract the numerical values of two columns of the same table by
specifying both the column names as the first and second operand. We can also subtract the
number from the existing number of the specific table column.

Syntax of SQL Subtraction Operator:

1. SELECT operand1 - operand2;

 This example consists of an Employee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_Monthlybonus.

Emp Id Emp_Id, Emp Na Emp Sa Emp_Salary Penalty

Emp_Name,me lary Emp_Monthlybonus.

201 Abhay 25000 200

202 Sumit 30000 500

o Suppose we want to subtract 5,000 from the salary of each employee given in
the Employee_details table. Then, we have to write the following query in the SQL:
1. SELECT Emp_Salary - 5000 as Emp_New_Salary FROM Employee_details;
In this query, we have performed the SQL subtraction operation on the single column of the
given table.

o If we want to subtract the penalty from the salary of each employee, then we have to
write the following query in SQL:
1. SELECT Emp_Salary - Penalty as Emp_Total_Salary FROM Employee_details;

SQL Multiplication Operator (*)

The Multiplication Operator in SQL performs the Multiplication on the numerical data of the
database table. In SQL, we can easily multiply the numerical values of two columns of the same
table by specifying both the column names as the first and second operand.

Syntax of SQL Multiplication Operator:

1. SELECT operand1 * operand2;

This example consists of an Employee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_Monthlybonus.

201 Abhay 25000 200

202 Sumit 30000 500

 o Suppose, we want to double the salary of each employee given in
the Employee_details table. Then, we have to write the following query in the SQL:
SELECT Emp_Salary * 2 as Emp_New_Salary FROM Employee_details;

o If we want to multiply the Emp_Id column to Emp_Salary column of that employee

whose Emp_Id is 202, then we have to write the following query in SQL:
SELECT Emp_Id * Emp_Salary as Emp_Id * Emp_Salary FROM Employee_details WHERE E
mp_Id = 202;
In this query, we have multiplied the values of two columns by using the WHERE clause.

SQL Division Operator (/)

The Division Operator in SQL divides the operand on the left side by the operand on the right
side.

Syntax of SQL Division Operator:

1. SELECT operand1 / operand2;

In SQL, we can also divide the numerical values of one column by another column of the same
table by specifying both column names as the first and second operand.

We can also perform the division operation on the stored numbers in the column of the SQL
table.

This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, and Emp_Salary.

201 Abhay 25000

202 Sumit 30000

o Suppose, we want to half the salary of each employee given in the Employee_details
table. For this operation, we have to write the following query in the SQL:
1. SELECT Emp_Salary / 2 as Emp_New_Salary FROM Employee_details;
In this query, we have performed the SQL division operation on the single column of the given
table.

SQL Modulus Operator (%)

 The Modulus Operator in SQL provides the remainder when the operand on the left side is
divided by the operand on the right side.

Syntax of SQL Modulus Operator:

1. SELECT operand1 % operand2;

Let's understand the below example which explains how to execute Modulus Operator in
SQL query:

This example consists of a Division table, which has three columns Number, First_operand,
and Second_operand.

Number Number, First o First_operand perand Secon Second_operand.

d operand

1 56 4

2 32 8

3 89 9

4 18 10

5 10 5

o If we want to get the remainder by dividing the numbers of First_operand column by the
numbers of Second_operand column, then we have to write the following query in SQL:
1. SELECT First_operand % Second_operand as Remainder FROM Employee_details;

SQL Logical Operators

 The Logical Operators in SQL perform the Boolean operations, which give two results True
and False. These operators provide True value if both operands match the logical condition.

Following are the various logical operators which are performed on the data stored in the
SQL database tables:

1. SQL ALL operator

2. SQL AND operator
3. SQL OR operator
4. SQL BETWEEN operator
5. SQL IN operator
6. SQL NOT operator
7. SQL ANY operator
8. SQL LIKE operator

The ALL operator in SQL compares the specified value to all the values of a column from the
sub-query in the SQL database.

This operator is always used with the following statement:

1. SELECT,
2. HAVING, and
3. WHERE.

Syntax of ALL operator:

1. SELECT column_Name1, ...., column_NameN FROM table_Name WHERE column Compariso

n_operator ALL (SELECT column FROM tablename2)
This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp_Id, Em Emp_Name, p Emp Sal Emp_Salary, EEmp_City.

Name ary
p City

201 Abhay 25000 Gurgaon

202 Ankit 45000 Delhi

203 Bheem 30000 Jaipur

 204 Ram 29000 Mumbai

205 Sumit 40000 Kolkata

o If we want to access the employee id and employee names of those employees from the
table whose salaries are greater than the salary of employees who lives in Jaipur city, then
we have to type the following query in SQL.
1. SELECT Emp_Id, Emp_Name FROM Employee_details WHERE Emp_Salary > ALL ( SELEC
T Emp_Salary FROM Employee_details WHERE Emp_City = Jaipur)
Here, we used the SQL ALL operator with greater than the operator.

SQL AND Operator

The AND operator in SQL would show the record from the database table if all the conditions
separated by the AND operator evaluated to True. It is also known as the conjunctive operator
and is used with the WHERE clause.

Syntax of AND operator:

1. SELECT column1, ...., columnN FROM table_Name WHERE condition1 AND condition2 AND
condition3 AND ....... AND conditionN;
This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Abhay 25000 Delhi

202 Ankit 45000 Chandigarh

203 Bheem 30000 Delhi

204 Ram 25000 Delhi

205 Sumit 40000 Kolkata

 o Suppose, we want to access all the records of those employees from
the Employee_details table whose salary is 25000 and the city is Delhi. For this, we have
to write the following query in SQL:
o SELECT * FROM Employee_details WHERE Emp_Salary = 25000 OR Emp_City = 'De
lhi';
Here,SQL AND operator with WHERE clause shows the record of employees whose
salary is 25000 and the city is Delhi.

SQL OR Operator
The OR operator in SQL shows the record from the table if any of the conditions separated by
the OR operator evaluates to True. It is also known as the conjunctive operator and is used with
the WHERE clause.

Syntax of OR operator:

1. SELECT column1, ...., columnN FROM table_Name WHERE condition1 OR condition2 OR co

ndition3 OR ....... OR conditionN;
This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Abhay 25000 Delhi

202 Ankit 45000 Chandigarh

203 Bheem 30000 Delhi

204 Ram 25000 Delhi

205 Sumit 40000 Kolkata

o If we want to access all the records of those employees from the Employee_details table
whose salary is 25000 or the city is Delhi. For this, we have to write the following query
in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Salary = 25000 OR Emp_City = 'Delhi';
 Here, SQL OR operator with WHERE clause shows the record of employees whose salary is
25000 or the city is Delhi.

SQL BETWEEN Operator

The BETWEEN operator in SQL shows the record within the range mentioned in the SQL
query. This operator operates on the numbers, characters, and date/time operands.

If there is no value in the given range, then this operator shows NULL value.

Syntax of BETWEEN operator:

1. SELECT column_Name1, column_Name2 ...., column_NameN FROM table_Name WHERE col

umn_nameBETWEEN value1 and value2;
This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Abhay 25000 Delhi

202 Ankit 45000 Chandigarh

203 Bheem 30000 Delhi

204 Ram 25000 Delhi

205 Sumit 40000 Kolkata

o Suppose, we want to access all the information of those employees from

the Employee_details table who is having salaries between 20000 and 40000. For this,
we have to write the following query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Salary BETWEEN 30000 AND 45000;
Here, we used the SQL BETWEEN operator with the Emp_Salary field.

SQL IN Operator
The IN operator in SQL allows database users to specify two or more values in a WHERE
clause. This logical operator minimizes the requirement of multiple OR conditions.
 This operator makes the query easier to learn and understand. This operator returns those rows
whose values match with any value of the given list.

Syntax of IN operator:

1. SELECT column_Name1, column_Name2 ...., column_NameN FROM table_Name WHERE col

umn_name IN (list_of_values);
This example consists of an Employee_details table, which has three columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Abhay 25000 Delhi

202 Ankit 45000 Chandigarh

203 Bheem 30000 Delhi

204 Ram 25000 Delhi

205 Sumit 40000 Kolkata

o Suppose, we want to show all the information of those employees from

the Employee_details table whose Employee Id is 202, 204, and 205. For this, we have
to write the following query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Id IN (202, 204, 205);
Here, we used the SQL IN operator with the Emp_Id column.

o Suppose, we want to show all the information of those employees from

the Employee_details table whose Employee Id is not equal to 202 and 205. For this, we
have to write the following query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Id NOT IN (202,205);
2.
Here, we used the SQL NOT IN operator with the Emp_Id column.
 SQL NOT Operator
The NOT operator in SQL shows the record from the table if the condition evaluates to false. It
is always used with the WHERE clause.

Syntax of NOT operator:

1. SELECT column1, column2 ...., columnN FROM table_Name WHERE NOT condition;
This example consists of an Employee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Abhay 25000 Delhi

202 Ankit 45000 Chandigarh

203 Bheem 30000 Delhi

204 Ram 25000 Delhi

205 Sumit 40000 Kolkata

o Suppose, we want to show all the information of those employees from

the Employee_details table whose Cityis not Delhi. For this, we have to write the
following query in SQL:
1. SELECT * FROM Employee_details WHERE NOT Emp_City = 'Delhi' ;
In this example, we used the SQL NOT operator with the Emp_City column.

o Suppose, we want to show all the information of those employees from

the Employee_details table whose Cityis not Delhi and Chandigarh. For this, we have to
write the following query in SQL:
1. SELECT * FROM Employee_details WHERE NOT Emp_City = 'Delhi' AND NOT Emp_City =
'Chandigarh';
In this example, we used the SQL NOT operator with the Emp_City column.
 SQL ANY Operator
The ANY operator in SQL shows the records when any of the values returned by the sub-query
meet the condition.

The ANY logical operator must match at least one record in the inner query and must be
preceded by any SQL comparison operator.

Syntax of ANY operator:

1. SELECT column1, column2 ...., columnN FROM table_Name WHERE column_name comparis
on_operator ANY ( SELECT column_name FROM table_name WHERE condition(s)) ;
SQL LIKE Operator
The LIKE operator in SQL shows those records from the table which match with the given
pattern specified in the sub-query.

The percentage (%) sign is a wildcard which is used in conjunction with this logical operator.

This operator is used in the WHERE clause with the following three statements:

1. SELECT statement
2. UPDATE statement
3. DELETE statement

Syntax of LIKE operator:

1. SELECT column_Name1, column_Name2 ...., column_NameN FROM table_Name WHERE col

umn_name LIKE pattern;
This example consists of an Employee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Chandigarh

203 Saket 30000 Delhi

204 Abhay 25000 Delhi

 205 Sumit 40000 Kolkata

o If we want to show all the information of those employees from

the Employee_details whose name starts with ''s''. For this, we have to write the
following query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Name LIKE 's%' ;
In this example, we used the SQL LIKE operator with Emp_Name column because we want to
access the record of those employees whose name starts with s.

o If we want to show all the information of those employees from

the Employee_detailswhose name ends with ''y''. For this, we have to write the following
query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Name LIKE '%y' ;

o If we want to show all the information of those employees from

the Employee_detailswhose name starts with ''S'' and ends with ''y''. For this, we have to
write the following query in SQL:
1. SELECT * FROM Employee_details WHERE Emp_Name LIKE 'S%y' ;

SQL Set Operators

The Set Operators in SQL combine a similar type of data from two or more SQL database
tables. It mixes the result, which is extracted from two or more SQL queries, into a single result.

Set operators combine more than one select statement in a single query and return a specific
result set.

Following are the various set operators which are performed on the similar data stored in
the two SQL database tables:

1. SQL Union Operator

2. SQL Union ALL Operator
3. SQL Intersect Operator
4. SQL Minus Operator

SQL Union Operator

The SQL Union Operator combines the result of two or more SELECT statements and provides
the single output.

The data type and the number of columns must be the same for each SELECT statement used
with the UNION operator. This operator does not show the duplicate records in the output table.

Syntax of UNION Set operator:

1. SELECT column1, column2 ...., columnN FROM table_Name1 [WHERE conditions]
2. UNION
3. SELECT column1, column2 ...., columnN FROM table_Name2 [WHERE conditions];
In this example, we used two tables. Both tables have four columns Emp_Id, Emp_Name,
Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Delhi

203 Saket 30000 Aligarh

Table: Employee_details1

Emp Id Emp Name Emp Salary Emp City

203 Saket 30000 Aligarh

204 Saurabh 40000 Delhi

205 Ram 30000 Kerala

201 Sanjay 25000 Delhi

Table: Employee_details2

o Suppose, we want to see the employee name and employee id of each employee from
both tables in a single output. For this, we have to write the following query in SQL:
1. SELECT Emp_ID, Emp_Name FROM Employee_details1
2. UNION
3. SELECT Emp_ID, Emp_Name FROM Employee_details2 ;
 SQL Union ALL Operator
The SQL Union Operator is the same as the UNION operator, but the only difference is that it
also shows the same record.

Syntax of UNION ALL Set operator:

1. SELECT column1, column2 ...., columnN FROM table_Name1 [WHERE conditions]

2. UNION ALL
3. SELECT column1, column2 ...., columnN FROM table_Name2 [WHERE conditions];
In this example, we used two tables. Both tables have four columns Emp_Id, Emp_Name,
Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Delhi

203 Saket 30000 Aligarh

Table: Employee_details1

Emp Id Emp Name Emp Salary Emp City

203 Saket 30000 Aligarh

204 Saurabh 40000 Delhi

205 Ram 30000 Kerala

201 Sanjay 25000 Delhi

Table: Employee_details2

o If we want to see the employee name of each employee of both tables in a single output.
For this, we have to write the following query in SQL:
1. SELECT Emp_Name FROM Employee_details1
2. UNION ALL
3. SELECT Emp_Name FROM Employee_details2 ;
SQL Intersect Operator
The SQL Intersect Operator shows the common record from two or more SELECT statements.
The data type and the number of columns must be the same for each SELECT statement used
with the INTERSECT operator.

Syntax of INTERSECT Set operator:

1. SELECT column1, column2 ...., columnN FROM table_Name1 [WHERE conditions]

INTERSECT
SELECT column1, column2 ...., columnN FROM table_Name2 [WHERE conditions];
In this example, we used two tables. Both tables have four columns Emp_Id, Emp_Name,
Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Delhi

203 Saket 30000 Aligarh

Table: Employee_details1

Emp Id Emp Name Emp Salary Emp City

203 Saket 30000 Aligarh

204 Saurabh 40000 Delhi

205 Ram 30000 Kerala

201 Sanjay 25000 Delhi

 Table: Employee_details2

Suppose, we want to see a common record of the employee from both the tables in a single
output. For this, we have to write the following query in SQL:

1. SELECT Emp_Name FROM Employee_details1

2. INTERSECT
3. SELECT Emp_Name FROM Employee_details2 ;
SQL Minus Operator
The SQL Minus Operator combines the result of two or more SELECT statements and shows
only the results from the first data set.

Syntax of MINUS operator:

1. SELECT column1, column2 ...., columnN FROM First_tablename [WHERE conditions]

2. MINUS
3. SELECT column1, column2 ...., columnN FROM Second_tablename [WHERE conditions];

In this example, we used two tables. Both tables have four columns Emp_Id, Emp_Name,
Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Delhi

203 Saket 30000 Aligarh

Table: Employee_details1

Emp Id Emp Name Emp Salary Emp City

203 Saket 30000 Aligarh

 204 Saurabh 40000 Delhi

205 Ram 30000 Kerala

201 Sanjay 25000 Delhi

Table: Employee_details2

Suppose, we want to see the name of employees from the first result set after the combination of
both tables. For this, we have to write the following query in SQL:

1. SELECT Emp_Name FROM Employee_details1

2. MINUS
3. SELECT Emp_Name FROM Employee_details2 ;

SQL Unary Operators

The Unary Operators in SQL perform the unary operations on the single data of the SQL table,
i.e., these operators operate only on one operand.

These types of operators can be easily operated on the numeric data value of the SQL table.

Following are the various unary operators which are performed on the numeric data
stored in the SQL table:

1. SQL Unary Positive Operator

2. SQL Unary Negative Operator
3. SQL Unary Bitwise NOT Operator

SQL Unary Positive Operator

The SQL Positive (+) operator makes the numeric value of the SQL table positive.

Syntax of Unary Positive Operator

1. SELECT +(column1), +(column2) ...., +(columnN) FROM table_Name [WHERE conditions] ;

This example consists of anEmployee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

 202 Ajay 45000 Chandigarh

203 Saket 30000 Delhi

204 Abhay 25000 Delhi

205 Sumit 40000 Kolkata

o Suppose, we want to see the salary of each employee as positive from the
Employee_details table. For this, we have to write the following query in SQL:
1. SELECT +Emp_Salary Employee_details ;
SQL Unary Negative Operator
The SQL Negative (-) operator makes the numeric value of the SQL table negative.

Syntax of Unary Negative Operator

1. SELECT -(column_Name1), -(column_Name2) ...., -(column_NameN) FROM table_Name [WH

ERE conditions] ;

This example consists of an Employee_details table, which has four columns Emp_Id,
Emp_Name, Emp_Salary, and Emp_City.

Emp Id Emp Name Emp Salary Emp City

201 Sanjay 25000 Delhi

202 Ajay 45000 Chandigarh

203 Saket 30000 Delhi

 204 Abhay 25000 Delhi

205 Sumit 40000 Kolkata

o Suppose, we want to see the salary of each employee as negative from the
Employee_details table. For this, we have to write the following query in SQL:
1. SELECT -Emp_Salary Employee_details ;

o Suppose, we want to see the salary of those employees as negative whose city is
Kolkatain the Employee_details table. For this, we have to write the following query in
SQL:
1. SELECT -Emp_Salary Employee_details WHERE Emp_City = 'Kolkata';
SQL Bitwise NOT Operator
The SQL Bitwise NOT operator provides the one's complement of the single numeric operand.
This operator turns each bit of numeric value. If the bit of any numerical value is 001100, then
this operator turns these bits into 110011.

Syntax of Bitwise NOT Operator

1. SELECT ~(column1), ~(column2) ...., ~(columnN) FROM table_Name [WHERE conditions] ;

This example consists of aStudent_details table, which has four columns Roll_No, Stu_Name,
Stu_Marks, and Stu_City.

Emp Id Stu Name Stu Marks Stu City

101 Sanjay 85 Delhi

102 Ajay 97 Chandigarh

103 Saket 45 Delhi

104 Abhay 68 Delhi

105 Sumit 60 Kolkata

 If we want to perform the Bitwise Not operator on the marks column of Student_details, we
have to write the following query in SQL:

1. SELECT ~Stu_Marks Employee_details ;

SQL Bitwise Operators

The Bitwise Operators in SQL perform the bit operations on the Integer values. To understand
the performance of Bitwise operators, you just knew the basics of Boolean algebra.

Following are the two important logical operators which are performed on the data stored
in the SQL database tables:

1. Bitwise AND (&)

2. Bitwise OR(|)

Bitwise AND (&)

The Bitwise AND operator performs the logical AND operation on the given Integer values. This
operator checks each bit of a value with the corresponding bit of another value.

Syntax of Bitwise AND Operator

1. SELECT column1 & column2 & .... & columnN FROM table_Name [WHERE conditions] ;
This example consists of the following table, which has two columns. Each column holds
numerical values.

When we use the Bitwise AND operator in SQL, then SQL converts the values of both columns
in binary format, and the AND operation is performed on the converted bits.

After that, SQL converts the resultant bits into user understandable format, i.e., decimal format.

Column1 Column2

1 1

2 5

3 4

4 2
 5 3

o Suppose, we want to perform the Bitwise AND operator between both the columns of the
above table. For this, we have to write the following query in SQL:
1. SELECT Column1 & Column2 From TABLE_AND ;
Bitwise OR (|)
The Bitwise OR operator performs the logical OR operation on the given Integer values. This
operator checks each bit of a value with the corresponding bit of another value.

Syntax of Bitwise OR Operator

1. SELECT column1 | column2 | .... | columnN FROM table_Name [WHERE conditions] ;

This example consists of a table that has two columns. Each column holds numerical values.

When we used the Bitwise OR operator in SQL, then SQL converts the values of both columns
in binary format, and the OR operation is performed on the binary bits. After that, SQL converts
the resultant binary bits into user understandable format, i.e., decimal format.

Column1 Column2

1 1

2 5

3 4

4 2

5 3

o Suppose, we want to perform the Bitwise OR operator between both the columns of the
above table. For this, we have to write the following query in SQL:
1. SELECT Column1 | Column2 From TABLE_OR ;