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 (name VARCHAR(20));
✓
INSERT INTO  t VALUES ('a'), ('b'), ('c'), ('d'), ('e'), ('f'),
                      ('a'), ('b'), ('c'), ('d'), ('e'), ('f');
✓
SELECT n FROM (SELECT random() n FROM t) WHERE CAST (n as INTEGER) > 0; 

n

4914739878548696000

-6740823871589006000

-1623774503611661600