Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
bitwise right shift (>>)
On this page
The 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.
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: