On 2014/03/05 12:04, Igor Korot wrote:
Hi, ALL,
Let's say I have a table with following data:
field1 field2 field3 field4
1 2 3 4
5 6 7 8
How do I write a query which will produce the output as:
1 2
5 6
3 4
7 8
Is it possible to write a single query which will produce the output like
this?
And not just in SQLite....
SELECT field1, field2 FROM tbl
UNION ALL
SELECT field3, field4 FROM tbl
I can't imagine a use for this... but hey....
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
