SQLite 3.39

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

CREATE TABLE t0 (id INT PRIMARY KEY, name TEXT, sortId INT);
✓
INSERT INTO t0 VALUES (1, 'C', NULL), (2, 'A', NULL), (3, 'B', NULL);
✓
WITH cte AS (SELECT *, ROW_NUMBER() OVER (ORDER BY name) AS rn FROM t0)
UPDATE t0
SET sortId = cte.rn
FROM cte
WHERE cte.id = t0.id;
✓
SELECT * FROM t0;


id
name
sortId


1
C
3

2
A
1

3
B
2