union all with order by

SQL UNION ALL operator is used to combine the result sets of two or more select statements .