SQL Server Order By Union with Example

Introduction

Here I will explain how to use order by in union query in sql server.

2. SELECT * FROM
3. (
4. Select Id as UserId, UserName as Name, RegisterDate From UserDetails
5. Union
6. select UserId, EmpName as Name, ModifyDate as RegisterDate From UserDetails
7. ) smptbl
8. ORDER BY RegisterDate DESC

If you observe above query we are getting data from union statements as sub query and applying order by statement sub query to show the data in descending order.

2. DECLARE @temp1 table(id int, name varchar(50),modifydate date)
3. DECLARE @temp2 table(id int, name varchar(50),modifydate date)
4. insert into @temp1(id,name,modifydate)
5. values(1,'Sesu,Raj','2017-01-30'),
6. (2,'Veera,Pandiayn','2016-02-10'),
7. (3,'Soosai,Raj','2015-03-05')
8. insert into @temp2(id,name,modifydate)
9. 
   
10. values(13,'Honey','2017-04-15'),
11. (21,'Imman,Alavala','2016-02-05'),
12. (21,'Jai,Ganesh','2015-01-20')
13. SELECT * FROM (
14. Select id,name, modifydate from @temp1
15. UNION
16. Select id,name, modifydate from @temp2
17. ) stbl ORDER BY modifydate DESC

Now we will see how to use order by clause with union statements in sql server with example.

If we execute above query we will get records in modifydate descending order.