On Wed, 2006-11-15 at 14:59 -0800, George Pavlov wrote: Alas, this suggestion is wrong on two counts: (a) UNION expects a single > ORDER BY that applies to the whole recordset and which has to come at > the end; (b) UNION re-sorts anyway (it needs to eliminate the dupes) -- > maybe you are thinking UNION ALL? So, to follow your advice he may want > a query like this, although it seems quite silly and there still isn't > an ironclad guarantee re. the final result sorting: > > select * from > (select * from foo where name != 'Other' order by name) x > union all > select * from foo where name = 'Other' > > Here ya go. select 1 SortCol, * from foo where name != 'Other' UNION ALL select 2 SortCol, * from foo where name = 'Other' order by SortCol;
