UNION and ORDER BY

Chaz · August 21st, 2009, 12:34 PM

Use index values from your select statement (note they start at 1 not 0)

For example if you have a select statement like this:
SELECT value1, value2, value3

Replace: ORDER BY value2, value3
With: ORDER BY 2, 3

This works with MySQL and Derby

Quote:

Originally Posted by grogi

Yes, this query works fine but if you only have distinct rows. If you have union from same table but with different filters then you'll have a duplicates in the result set because of the column OrderBY.

October 10th, 2009, 07:52 AM

I would suggest to code like this

select
name,
dob,
title
from
(
select tblA.name,tblA.CreateDay as dob,tblA.title
from tblA

union

select tblB.name,tblB.JoiningDATE as dob,tblB.title
from tblB

) unioned -- this can be any name including yours but its a must as it works --as alias
order by dob desc

happy coding