SQLite - Row

Sqlite Banner


A page about all row scope subject in Sqlite.


Sqlite has an internal rowid

Row Number

The row_number() function window function returns the id of the row

(ie It's not the ID in the table).


  • Row Number applied over the whole table
select ROW_NUMBER() over (), * from myTable;

Share this page:
Follow us:
Task Runner