XQuery order by ascending and descending

Question

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

score 21 · Accepted Answer · edited Feb 19 '14 at 06:54

21

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:

edited Feb 19 '14 at 06:54

modulitos

answered May 14 '11 at 11:01

Lucero

so it would befor $x in doc("books.xml")/bookstore/book where $x/price>30 order by ascending $x/title return $x/title – Tuffy G May 14 '11 at 11:04
or would it be for $x in doc("books.xml")/bookstore/book where $x/price>30 order by $x/title return $x/title ascending – Tuffy G May 14 '11 at 11:16
I wrote "after the expression", which I meant like this: `... order by $x/title ascending ...` (just like you wrote in your question, this is the correct syntax). – Lucero May 14 '11 at 11:23

score 1 · Answer 2 · edited May 23 '17 at 12:34

1

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

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

edited May 23 '17 at 12:34

Community

answered May 18 '11 at 05:17

Dimitre Novatchev

2 Answers2