SQL Query – Using Order By in UNION

by

Sometimes you need to have the ORDER BY in each of the sections that need to be combined with UNION.

In this case

SELECT * FROM 
(
  SELECT table1.field1 FROM table1 ORDER BY table1.field1
) DUMMY_ALIAS1

UNION ALL

SELECT * FROM
( 
  SELECT table2.field1 FROM table2 ORDER BY table2.field1
) DUMMY_ALIAS2

More Related Contents:

  1. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  2. How to order by with union in SQL?
  3. SQL how to make null values come last when sorting ascending
  4. Sorting null values after all others, except special
  5. How to use SQL Order By statement to sort results case insensitive?
  6. SQL Server UNION – What is the default ORDER BY Behaviour
  7. Alphanumeric sorting with PostgreSQL
  8. MySQL: Alternatives to ORDER BY RAND()
  9. Upserting in MS-access
  10. What is the difference between JOIN and UNION?
  11. How to simulate UNPIVOT in Access?
  12. How do I count unique items in field in Access query?
  13. Date Difference between consecutive rows
  14. Pivoting data in MS Access
  15. coalesce alternative in Access SQL
  16. Using Excel VBA to export data to MS Access table
  17. Top n records per group sql in access
  18. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  19. How do I return rows with a specific value first?
  20. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  21. Why does a LIKE query in Access not return any records?
  22. How to SUM two fields within an SQL query
  23. PostgreSQL ORDER BY issue – natural sort
  24. How to use system username directly in MS Access query?
  25. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  26. can we list all tables in msaccess database using sql?
  27. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  28. SQL Updating from an inner join
  29. How to delete in MS Access when using JOIN’s?
  30. How to save the result of a SQL query into a variable in VBA?

Leave a Comment