This doesn’t really answer the question, but it seems to be a parser bug (or ‘feature’) rather than a language requirement. According to My Oracle Support, this seems to have been raised as bug 14196463 but closed with no resolution. It’s also mentioned in community thread 3561546. You need a MOS account, or at least … Read more
I notice this question gets quite a lot of views so I’ll first address a question you didn’t ask! Regarding the title. To achieve a “Sql Union All with “distinct”” then simply replace UNION ALL with UNION. This has the effect of removing duplicates. For your specific question, given the clarification “The first query should … Read more
Here is the answer you are looking for. Use the Concat keyword. From the example: var query = (from x in db.Table1 select new {A = x.A, B = x.B}) .Concat( from y in db.Table2 select new {A = y.A, B = y.B} );
Put your order by and top statements into sub-queries: select first.Id, first.Name from ( select top 1 * from Locations order by Id) first union all select last.Id, last.Name from ( select top 1 * from Locations order by Id desc) last
UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not. There is a performance hit when using UNION instead of UNION ALL, since the database server must do additional work to remove the duplicate rows, but usually you do not want the duplicates (especially when developing reports). To … Read more