SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE accounts ( id int, amount int ); INSERT INTO accounts VALUES (1, 10), (2, 20), (3, 30); SELECT json_agg(id), array_agg(id order by id desc), string_agg(id::varchar, ','), SUM(amount) FROM accounts;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear