# SEGMENT\_ID

Segment\_ID() returns the segment ID associated with the row in a table.

## Syntax

```sql
SELECT a, SEGMENT_ID(t) FROM t WHERE SEGMENT_ID(t) = 1;
```

## Return Type

Integer.

## Example

```sql
SELECT asset_desc, SEGMENT_ID(assets) FROM assets WHERE SEGMENT_ID(assets) = 3000002;


```

```output

+-----------------+--------------------+
| asset_desc      | segment_id(assets) |
+-----------------+--------------------+
| mac_book_pro    |            3000002 |
| mac_book_pro    |            3000002 |
| iphone_13       |            3000002 |
| mac_book_air_M1 |            3000002 |
| mac_book_pro    |            3000002 |
+-----------------+--------------------+
```

> **📝 Note**: This built-in works only on columnstore tables.

## Related Info

* [COLUMNAR\_SEGMENTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/columnar-segments.md)
* See [JSON\_AGG](https://docs.singlestore.com/db/v9.1/reference/sql-reference/json-functions/json-agg.md) for the table and values used in the example above.

***

Modified at: March 11, 2024

Source: [/db/v9.1/reference/sql-reference/information-functions/segment-id/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/information-functions/segment-id/)

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