`ROW_NUMBER`

Show body

Ciro Santilli 34 Updated 2024-11-19 Created 1970-01-01

sqlite3 ':memory:'  'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over () FROM t'

Possible output:

-1|1
-1|2
-2|3

Gives them unique IDs.

With a partition by:

sqlite3 ':memory:'  'WITH t (i) AS (VALUES (-1), (-1), (-2)) SELECT *, row_number() over ( partition by i ) FROM t'

possible output:

-2|1
-1|1
-1|2