SQLite - Row
About
A page about all row scope subject in Sqlite.
RowID
Sqlite has an internal rowid
Row Number
The row_number() function window function returns the id of the row
- over the result set
- or a partition key
(ie It's not the ID in the table).
Example:
- Row Number applied over the whole table
select ROW_NUMBER() over (), * from myTable;