SELECT STRING_AGG(k, ','), SUM(CAST(k AS BIGINT)) FROM (SELECT CAST(g AS VARCHAR) FROM strings UNION ALL SELECT CAST(x AS VARCHAR) FROM strings) tbl1(k) ...
CREATE TABLE strings AS SELECT c::VARCHAR g, (c*10+e)::VARCHAR x FROM range(0, 100, 1) t1(c), range(0, 100, 1) t2(e); ...
SQLite 3.44 has been released with new C-language APIs and extensions to aggregate functions. SQLite is a widely deployed database, and is compact, with a library size of under 600KB with all features ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results