Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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