CodeJackpot - SQL Operators

SQL Operators

Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases. SQL operators are used to perform various operations on data stored in a database. These operators are classified into different categories based on their functionality.

Arithmetic Operators

Arithmetic operators are used to perform mathematical operations on numeric data types. The following are the arithmetic operators in SQL:

Here is an example of using arithmetic operators:

SELECT 10 + 5;
SELECT 10 - 5;
SELECT 10 * 5;
SELECT 10 / 5;
SELECT 10 % 5;

Comparison Operators

Comparison operators are used to compare two values. The following are the comparison operators in SQL:

=
<> or !=
<
<=
>
>=

Here is an example of using comparison operators:

SELECT * FROM customers WHERE age = 25;
SELECT * FROM customers WHERE age < 25;
SELECT * FROM customers WHERE age >= 25;
SELECT * FROM customers WHERE name != 'John';

Logical Operators

Logical operators are used to combine two or more conditions. The following are the logical operators in SQL:

Here is an example of using logical operators:

SELECT * FROM customers WHERE age >= 25 AND city = 'New York';
SELECT * FROM customers WHERE age < 25 OR city = 'Los Angeles';
SELECT * FROM customers WHERE NOT age = 25;

Bitwise Operators

Bitwise operators are used to perform operations on binary data. The following are the bitwise operators in SQL:

Here is an example of using bitwise operators:

SELECT 10 & 5;
SELECT 10 | 5;
SELECT 10 ^ 5;
SELECT ~10;
SELECT 10 << 2;
SELECT 10 >> 2;

Reference

For more information on SQL operators, please refer to the following resources:

SQL