Ciro Santilli Basic example tested on SQLite 3.40.1, Ubuntu 23.04:
output:
sqlite3 :memory: 'select 1 union select 2'1
2Two columns two rows:
output:
sqlite3 :memory: <<EOF
select * from (values (1, 2), (2, 3))
union
select * from (values (2, 3), (3, 4))
EOF1|2
2|3
3|4Note how duplicates are removed, to keep them we
output:
UNION ALL instead:
sqlite3 :memory: <<EOF
select * from (values (1, 2), (2, 3))
union all
select * from (values (2, 3), (3, 4))
EOF1|2
2|3
2|3
3|4