SQL Operators

🎓 Top 15 Udemy Courses (80-90% Discount): My Udemy Courses - Ramesh Fadatare — All my Udemy courses are real-time and project oriented courses.

▶️ Subscribe to My YouTube Channel (178K+ subscribers): Java Guides on YouTube

▶️ For AI, ChatGPT, Web, Tech, and Generative AI, subscribe to another channel: Ramesh Fadatare on YouTube

Introduction

In this chapter, we will explore SQL operators, which are used to perform operations on data in a database. Operators are essential in SQL as they allow you to filter results, perform calculations, and manipulate data. This chapter will cover the different types of SQL operators, including arithmetic, comparison, logical, and more, with examples to help you understand how to use them.

Types of SQL Operators

1. Arithmetic Operators
2. Comparison Operators
3. Logical Operators
4. Bitwise Operators
5. Compound Operators
6. Other Operators

1. Arithmetic Operators

Arithmetic operators are used to perform mathematical operations on numeric data.

Table of Arithmetic Operators

Operator	Description	Example	Result
+	Addition	5 + 3	8
-	Subtraction	5 - 3	2
*	Multiplication	5 * 3	15
/	Division	5 / 2	2.5
%	Modulus	5 % 2	1

Example

SELECT price, price * 0.1 AS tax
FROM products;

2. Comparison Operators

Comparison operators are used to compare two values and return a boolean value (TRUE or FALSE).

Table of Comparison Operators

Operator	Description	Example	Result
=	Equal to	5 = 3	FALSE
!=	Not equal to	5 != 3	TRUE
>	Greater than	5 > 3	TRUE
<	Less than	5 < 3	FALSE
>=	Greater than or equal to	5 >= 3	TRUE
<=	Less than or equal to	5 <= 3	FALSE

Example

SELECT product_name, price
FROM products
WHERE price > 100;

3. Logical Operators

Logical operators are used to combine multiple conditions in SQL statements.

Table of Logical Operators

Operator	Description	Example	Result
AND	Logical AND	TRUE AND FALSE	FALSE
OR	Logical OR	TRUE OR FALSE	TRUE
NOT	Logical NOT	NOT TRUE	FALSE

Example

SELECT product_name, price
FROM products
WHERE price > 100 AND category = 'Electronics';

4. Bitwise Operators

Bitwise operators are used to perform bit-level operations on binary numbers.

Table of Bitwise Operators

Operator	Description	Example	Result
&	Bitwise AND	5 & 3	1
|	Bitwise OR	5 | 3	7
^	Bitwise XOR	5 ^ 3	6
~	Bitwise NOT	~5	-6
<<	Left Shift	5 << 1	10
>>	Right Shift	5 >> 1	2

Example

SELECT 5 & 3 AS BitwiseAND, 5 | 3 AS BitwiseOR;

5. Compound Operators

Compound operators combine arithmetic operations with assignment.

Table of Compound Operators

Operator	Description	Example	Equivalent To
+=	Add and assign	a += 5	a = a + 5
-=	Subtract and assign	a -= 5	a = a - 5
*=	Multiply and assign	a *= 5	a = a * 5
/=	Divide and assign	a /= 5	a = a / 5
%=	Modulus and assign	a %= 5	a = a % 5

Example

UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 5;

6. Other Operators

LIKE Operator

The LIKE operator is used for pattern matching in strings.

Table of LIKE Operator

Pattern	Description	Example	Matches
%	Matches any sequence of characters	'A%'	'Apple', 'Amazing'
_	Matches any single character	'A_'	'An', 'At'

Example

SELECT product_name
FROM products
WHERE product_name LIKE 'A%';

IN Operator

The IN operator is used to specify multiple values in a WHERE clause.

Example

SELECT first_name, last_name
FROM employees
WHERE department_id IN (1, 2, 3);

BETWEEN Operator

The BETWEEN operator selects values within a given range.

Example

SELECT product_name, price
FROM products
WHERE price BETWEEN 100 AND 200;

IS NULL Operator

The IS NULL operator is used to filter rows with NULL values.

Example

SELECT first_name, last_name
FROM employees
WHERE email IS NULL;

Conclusion

SQL operators are used for manipulating and querying data in a database. This chapter covered various types of operators, including arithmetic, comparison, logical, bitwise, compound, and other useful operators. Understanding these operators will help you write more effective and efficient SQL queries.

My Top and Bestseller Udemy Courses. The sale is going on with a 70 - 80% discount. The discount coupon has been added to each course below:

Build REST APIs with Spring Boot 4, Spring Security 7, and JWT

🆕 High-Demand 80–90% OFF

[NEW] Learn Apache Maven with IntelliJ IDEA and Java 25

🆕 High-Demand 80–90% OFF

ChatGPT + Generative AI + Prompt Engineering for Beginners

🚀 Trending Now 80–90% OFF

Spring 7 and Spring Boot 4 for Beginners (Includes 8 Projects)

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Building Real-Time REST APIs with Spring Boot - Blog App

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Building Microservices with Spring Boot and Spring Cloud

🌟 Top Rated 80–90% OFF
Available in Udemy for Business

Java Full-Stack Developer Course with Spring Boot and React JS

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Build 5 Spring Boot Projects with Java: Line-by-Line Coding

🌟 Top Rated 80–90% OFF

Testing Spring Boot Application with JUnit and Mockito

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Spring Boot Thymeleaf Real-Time Web Application - Blog App

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Master Spring Data JPA with Hibernate

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Spring Boot + Apache Kafka Course - The Practical Guide

🎓 Student Favorite 80–90% OFF
Available in Udemy for Business

Java Testing: Mastering JUnit 5 Framework

🆕 New 80–90% OFF

Reactive Programming in Java: Spring WebFlux and Testing

🌟 Top Rated 80–90% OFF

Spring Boot + RabbitMQ Course - The Practical Guide

🌟 Top Rated 80–90% OFF
Available in Udemy for Business

Functional Programming in Java (Includes Java Collections)

🎓 Student Favorite 80–90% OFF

ChatGPT for Java Developers: Boost Your Productivity with AI

🚀 Trending Now 80–90% OFF