Personal website Rudolf Adamkovič

Home / SQLite


Example: Sum identity

CREATE TABLE t(k, a);
CREATE TABLE u(k, b);

INSERT INTO t(k, a) VALUES (1, 10), (2, 20), (3, 30);

SELECT
  ifnull(sum(a), 0) as 'sum(a)',
  ifnull(sum(b), 0) as 'sum(b)'
  FROM t FULL OUTER JOIN u ON u.k = t.k;
sum(a) sum(b)
60 0

© 2025 Rudolf Adamkovič under GNU General Public License version 3.
Made with Emacs and secret alien technologies of yesteryear.