SQL Bitwise Operators
Bitwise operators in SQL are used to perform bitwise operations on binary values in SQL queries, manipulating individual bits to perform logical operations at the bit level. Some SQL Bitwise Operators are:
|
Operator |
Description |
|---|---|
|
& |
Bitwise AND operator |
|
| |
Bitwise OR operator |
|
^ |
Bitwise XOR (exclusive OR) operator |
|
~ |
Bitwise NOT (complement) operator |
|
<< |
Left shift operator |
|
>> |
Right shift operator |
SQL Operators
SQL Operators perform arithmetic, comparison, and logical operations to manipulate and retrieve data from databases.
In this article, we will discuss Operators in SQL with examples, and understand how they work in SQL.