Well, it doesn't error out! In this example, it seems like it picks the result from whatever matches the last column, but not sure if this is determinstic:

Well, it doesn't error out! In this example, it seems like it picks the result from whatever matches the last column, but not sure if this is determinstic: sqlite> create table x(c1, c2); sqlite> insert into x values ("a", 1); sqlite> insert into x values ("b", 2); sqlite> insert into x values ("c", 3); sqlite> select c1, max(c2) from x; c|3 sqlite> select c1, max(c2), min(c2) from x; a|3|1 sqlite> select c1, min(c2), max(c2) from x; c|1|3 (note: since SQLite is dynamically typed, no need to specify column types for simple examples like this).