XQuery order ascending and descending

Question

In XQuery, how do you order ascending and descending?

I have the following from a tutorial:

for $x in doc("books.xml")/bookstore/book where $x/price>30 order by $x/title return $x/title 

would

 for $x in doc("books.xml")/bookstore/book where $x/price>30 order by $x/title ascending return $x/title 

Answer 1

Yes, you can use ascending (the default) or descending at the end of the order by.. expression.

Here is a link to the relevant part of the W3C XQuery specification:

http://www.w3.org/TR/xquery/#doc-xquery-OrderSpec

Answer 2

See my answer to this question . The code shows the order in descending order.

For ascending order, the ascending keyword may be omitted.