Hi, try with: select * from ( select id, name, sum(amount) as mysum from one where v_date between '2010-01-05' and '2010-01-06' group by id, name union select id, name, sum(amount) as mysum from one where v_date < '2010-01-05' group by id, name ) x order by name ;
regards Dario El 02/12/10 10:13, Kuttan escribió: > Hi > > Is it possible to apply order by for a union query and how. > > eg: > > create table one(id int auto_increment, v_date date, name varchar(20), > amount double) > > insert into one values(default, '2010-01-04', 'abcd', 400) > insert into one values(default, '2010-01-04', 'efgh', 400) > insert into one values(default, '2010-01-04', 'ijkl', 400) > insert into one values(default, '2010-01-05', 'abcd', 500) > insert into one values(default, '2010-01-05', 'efgh', 500) > insert into one values(default, '2010-01-05', 'ijkl', 500) > insert into one values(default, '2010-01-06', 'abcd', 600) > insert into one values(default, '2010-01-06', 'efgh', 600) > insert into one values(default, '2010-01-06', 'ijkl', 600) > > now i run the below queries: > Query 1 > ====== > select id, name sum(amount) from one where v_date between '2010-01-05' > and '2010-01-06' group by id, name order by name > Query 2 > ====== > select id, name sum(amount) from one where v_date < '2010-01-05' group > by id, name order by name > > required result > ============ > the result obtained in query 1 and query 2 should be obtained by > running 1 query some thing like > select id, name sum(amount) from one where v_date between '2010-01-05' > and '2010-01-06' group by id, name order by name union select id, name > sum(amount) from one where v_date < '2010-01-05' group by id, name > order by name > > Thanking you > > Regds - K. Prakash > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
