# bitwise right shift (>>)

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. 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: June 29, 2026

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)