SQLite 3.39

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

select sqlite_version();


sqlite_version()


3.39.1


CREATE TABLE t(v VARCHAR(255));

✓
INSERT INTO t(v) VALUES ('300') , ('200'),('100'), ('10'), ('8'), ('5'), ('3'), ('1');
✓
SELECT t1.v, COUNT(t2.v) + 1 AS row_num
    
FROM t t1
LEFT JOIN
    t t2
ON
    LENGTH(t1.v) < LENGTH(t2.v)
    OR (LENGTH(t1.v) = LENGTH(t2.v) AND t1.v < t2.v)
GROUP BY
    t1.v
ORDER BY
    LENGTH(t1.v) DESC, t1.v DESC;


v
row_num


300
1

200
2

100
3

10
4

8
5

5
6

3
7

1
8