This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
Course Of The Month
3 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL - order result set when using union
Posted on 2016-08-24
When using union all, how can I order result set of how it gets displayed? For example
Right now it returned
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
Sale Direct 1 $ $ $
Manager Resell 1 $ $ $
Inter Extr 1 $ $ $
Exter EU 1 $ $ $
I want to return like or any order of result set
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
Inter Extr 1 $ $ $
Exter EU 1 $ $ $
Manager Resell 1 $ $ $
Sale Direct 1 $ $ $
Table sample
column names
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
select *from
(
select * from #temp_table1
union all
select * from #temp_table2
union all
select * from #temp_table3
union all
select * from #temp_table4
a group by Descripton,SalesType,Custo
Right now it returned
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
Sale Direct 1 $ $ $
Manager Resell 1 $ $ $
Inter Extr 1 $ $ $
Exter EU 1 $ $ $
I want to return like or any order of result set
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
Inter Extr 1 $ $ $
Exter EU 1 $ $ $
Manager Resell 1 $ $ $
Sale Direct 1 $ $ $
Table sample
column names
Descripton SalesType Customercode Jan Feb Mar Apr May Jun Jul Aug Oct Nov Dec Total
select *from
(
select * from #temp_table1
union all
select * from #temp_table2
union all
select * from #temp_table3
union all
select * from #temp_table4
a group by Descripton,SalesType,Custo
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active today
To pull off a customized ordering you'll need to include an ORDER BY with a CASE block, like this..
<total air code, look at the last line>
For a tutorial on CASE blocks check out SQL Server CASE Solutions.
<total air code, look at the last line>
select * from (
select * from #temp_table1
union all
select * from #temp_table2
union all
select * from #temp_table3
union all
select * from #temp_table4) a
group by Descripton,SalesType,Customercode,Jan,Feb ,Mar Apr,May,Jun,Jul,Aug,Oct,Nov,Dec,Total
ORDER BY CASE Descripton
WHEN 'Inter' THEN 1
WHEN 'Exter' THEN 2
WHEN 'Manager' THEN 3
WHEN 'Sale' THEN 4
ELSE 5 END
For a tutorial on CASE blocks check out SQL Server CASE Solutions.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses
Course of the Month3 days, 8 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.