SQL Server UNION – What is the default ORDER BY Behaviour

by

There is no default order.

Without an Order By clause the order returned is undefined. That means SQL Server can bring them back in any order it likes.

EDIT:
Based on what I have seen, without an Order By, the order that the results come back in depends on the query plan. So if there is an index that it is using, the result may come back in that order but again there is no guarantee.

More Related Contents:

  1. How to order by with union in SQL?
  2. SQL Query – Using Order By in UNION
  3. When no ‘Order by’ is specified, what order does a query choose for your record set?
  4. How to update and order by using ms sql
  5. “Order By” using a parameter for the column name
  6. UNION the results of multiple stored procedures
  7. how does SELECT TOP works when no order by is specified?
  8. How to get results in a custom order? [closed]
  9. Dynamic order direction
  10. How do I obtain a Query Execution Plan in SQL Server?
  11. MySQL: Alternatives to ORDER BY RAND()
  12. sql query to return differences between two tables
  13. SQL Server 2005 How Create a Unique Constraint?
  14. SQL Server: Make all UPPER case to Proper Case/Title Case
  15. How do I delete from multiple tables using INNER JOIN in SQL server
  16. Does Foreign Key improve query performance?
  17. What is a ‘multi-part identifier’ and why can’t it be bound?
  18. SQL Server convert string to datetime
  19. sql server select first row from a group
  20. Check If the string contains accented characters in SQL?
  21. Count based on condition in SQL Server
  22. What does sp_reset_connection do?
  23. Replace first occurrence of substring in a string in SQL
  24. How to correctly insert newline in nvarchar [duplicate]
  25. How do you copy a record in a SQL table but swap out the unique id of the new row?
  26. Using IF ELSE statement based on Count to execute different Insert statements
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Add a row number to result set of a SQL query
  29. How to get the next number in a sequence
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment