|
[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message] RE: XQuery Order By NumericallyMichael Kay mike at saxonica.comFri Feb 29 16:39:16 PST 2008
Use
order by xs:integer($x)
Michael Kay
http://www.saxonica.com/
> -----Original Message-----
> From: http://x-query.com/mailman/listinfo/talk [mailto:http://x-query.com/mailman/listinfo/talk]
> Sent: 29 February 2008 16:29
> To: http://x-query.com/mailman/listinfo/talk
> Cc: Michael Kay
> Subject: XQuery Order By Numerically
>
> Hi all,
>
> The ORDER BY clause sorts the output alphabetically. However,
> how do I sort the output numerically? Is this possible in XQuery?
>
> For example, if the input is = {1, 11, 2, 1234, 4, 123), then
> the ORDER BY clause sorts the results as {1, 11, 123, 1234, 2, 4).
>
> How can I sort the results as {1, 2, 4, 11, 123, 1234}?
>
> Thanks!
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|






