Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
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