`monotonically_increasing_id` function

Applies to: check marked yes Databricks SQL Databricks Runtime

Returns monotonically increasing 64-bit integers.

Syntax

monotonically_increasing_id()

Arguments

This function takes no arguments.

Returns

A BIGINT.

The generated ID is guaranteed to be monotonically increasing and unique, but not consecutive.

Examples

> SELECT monotonically_increasing_id();
 0