Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

bitwise right shift (>>)

Moves all of the bits of num1 to the right by num2 places. Each place shifted is equivalent to dividing by 2. Remainders (the 0.5 when dividing an odd number) are thrown away.

Syntax

num1 >> num2

Return Type

Integer

Examples

select 8>>1, bin(8), bin(8>>1);
+------+--------+-----------+
| 8>>1 | bin(8) | bin(8>>1) |
+------+--------+-----------+
|    4 | 1000   | 100       |
+------+--------+-----------+

select 7>>1, bin(7), bin(7>>1);
+------+--------+-----------+
| 7>>1 | bin(7) | bin(7>>1) |
+------+--------+-----------+
|    3 | 111    | 11        |
+------+--------+-----------+