SQLize Online / PHPize Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE a ( id INTEGER PRIMARY KEY, arr VARCHAR(150)[] NULL ); INSERT INTO a (id, arr) VALUES (1, ARRAY['1a','3','2']); INSERT INTO a (id, arr) VALUES (2, ARRAY[1,1,1]); INSERT INTO a (id, arr) VALUES (3, '{123,123,abc,1a}'); SELECT row_number () over W, rank () over W FROM a WINDOW W AS (order by id);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy