union wth order by clause

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