Does UNION ALL guarantee the order of the result set [duplicate]

by

There is no inherent order, you have to use ORDER BY. For your example you can easily do this by adding a SortOrder to each SELECT. This will then keep the records in the order you want:

SELECT 'O', 1 SortOrder
UNION ALL
SELECT 'R', 2
UNION ALL
SELECT 'D', 3
UNION ALL
SELECT 'E', 4
UNION ALL
SELECT 'R', 5
ORDER BY SortOrder

You cannot guarantee the order unless you specifically provide an order by with the query.

More Related Contents:

  1. Get the mentioned output by SQL query
  2. SQL Server Subquery a
  3. Calculate a Running Total in SQL Server
  4. Not equal != operator on NULL
  5. SET NOCOUNT ON usage
  6. How can I get column names from a table in SQL Server?
  7. LIMIT 10..20 in SQL Server
  8. Copy tables from one database to another in SQL Server
  9. error, string or binary data would be truncated when trying to insert
  10. How to fetch the row count for all tables in a SQL SERVER database [duplicate]
  11. WHERE Clause vs ON when using JOIN
  12. Using a Variable in OPENROWSET Query
  13. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  14. Does MS SQL Server’s “between” include the range boundaries?
  15. Check for file exists or not in sql server?
  16. How to get the first and last date of the current year?
  17. Split one column value into multiple column values
  18. Why execute stored procedures is faster than SQL query from a script?
  19. T-SQL – Aliasing using “=” versus “as” [closed]
  20. How to install localdb separately?
  21. Know relationships between all the tables of database in SQL Server
  22. Difference between “read commited” and “repeatable read” in SQL Server
  23. How do I create and query linked database servers in SQL Server?
  24. How to return a incremental group number per group in SQL
  25. Retrieve column names and types of a stored procedure? [duplicate]
  26. Add emoji / emoticon to SQL Server table
  27. How do I change db schema to dbo
  28. Is there a severe performance hit for using Foreign Keys in SQL Server?
  29. Date serial in SQL?
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment