bitwise right shift (>>)
On this page
Moves all of the bits of num1 to the right by num2 places.
Each place shifted is equivalent to dividing by 2.
Syntax
num1 >> num2Return 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 |
+------+--------+-----------+Last modified: February 24, 2023