Using Order by in UNION Clause in SQL SERVER

SELECT * FROM
( SELECT Column1 FROM table1
  UNION
  SELECT Column1 FROM table2
)
ORDER BY Column1

About these ads