Ordered and Unordered Expressions (XQuery)
Applies to: 
SQL Server
By default, the ordering mode for all operations in SQL Server is ordered. Therefore, the node sequences returned by the path expressions and the FLWOR expressions, without the order by clause, are in document order.
The additional ordered and unordered syntax described in the XQuery specification is not supported.
See Also
XQuery Expressions
FLWOR Statement and Iteration (XQuery)
Path Expressions (XQuery)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for