# 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

```sql
SELECT 8>>1, bin(8), bin(8>>1);

```

```output

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

```

```sql
SELECT 7>>1, bin(7), bin(7>>1);

```

```output

+------+--------+-----------+
| 7>>1 | bin(7) | bin(7>>1) |
+------+--------+-----------+
|    3 | 111    | 11        |
+------+--------+-----------+
```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/bitwise-right-shift/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/bitwise-right-shift/)

(An index of the documentation is available at /llms.txt)