Hello All,
create table a (i int);
create table b(i int);
insert into a values(1);
insert into b values(2);
select * from a union all select * from b;
My understanding is the result should be showing at screen as a result
of such 1, 2 ... order but our resulted is showing as 2 1 .on screen.
I tested it on db2, informix, soliddb, mssql, oracle. but db2 only
differ from others. Please let me know why?