SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mock (ID INTEGER PRIMARY KEY, Name VARCHAR(30));
INSERT INTO mock (ID, Name) VALUES
(11, 'user1'),
(15, 'user2'),
(17, 'user3');
SELECT * FROM mock;


ID
Name


11
user1

15
user2

17
user3


SELECT ROW_NUMBER() OVER (ORDER BY ID) AS RowNum
, ID, Name
FROM mock;


RowNum
ID
Name


1
11
user1

2
15
user2

3
17
user3