ORDER BY Clause
Topic Last Modified: 2006-06-13
The Structured Query Language (SQL) ORDER BY clause sorts the returned recordset in ascending or descending order according to one or more properties specified.
ORDER BY [[propertyName] ASC|DESC], [[propertyName] ASC|DESC], [...]
The parameter propertyName specifies properties selected in your SQL query that you want to group.
The parameters "asc" and "desc" specify the sort order. To sort in ascending order, A-Z, specify "asc". To sort in descending order, Z-A, specify "desc". Sorting can also be done numerically.
Remarks
You cannot use ORDER BY on properties in the Exchange store that are calculated. For a list of these properties, see Non-Searchable Properties.
Example
The following is an example of a SELECT Statement that searches the specified folder for only folder resources, and sorts the results in ascending order by displayname Field values.
strSQL = "SELECT ""DAV:displayname""
strSQL = strSQL & "FROM scope('shallow traversal of "http://myserver/public/test/""')"
strSQL = strSQL & "WHERE ""DAV:isfolder"" = TRUE"
strSQL = strSQL & "ORDER BY ""DAV:displayname"" ASC"