CODEWITHSUNDEEP
xmlxquery
Tuffy G
Tuffy G

Reputation: 1521

XQuery order by ascending and descending

In XQuery, How do you order by ascending and descending?

I have got 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 it be

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

Upvotes: 16

Views: 55245

Answers (2)

Lucero
Lucero

Reputation: 60190

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

Here's the link to the relevant part of the W3C XQuery spec:

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

Upvotes: 21

Dimitre Novatchev
Dimitre Novatchev

Reputation: 243449

See my answer to this question. The code demonstrates ordering in descending order.

For ordering in ascending order, the ascending keyword can be ommitted.

Upvotes: 1

Related Questions