Sorting Results (Work Item Query Reference)
You can use the order by clause to sort the results of a query by one or more fields in ascending or descending order.
Note
The sorting preferences of the SQL server on the data tier determine the default sort order. However, you can use the asc or desc parameter to choose an explicit sort order.
The example sorts work items first by Priority in ascending order, and then by Created Date in descending order.
Example
SELECT [System.Title] FROM workitems WHERE [System.State] = ‘Active' and [System.AssignedTo] = ‘joselugo' order by [Microsoft.VSTS.Common.Priority] asc, [System.CreatedDate] desc