XML Publisher - How to do sorting on the XML dataset

How to do sorting in XMLP
---------------------------
Sorting can be done by inserting the tag within the repeating group.

Multiple sorts is possible by using multiple sort tags


There is no end tag required for this XMLP directive.

Ascending or descending order sorting is also possible using the following syntax
order='descending'?>

Data type sorting is also possible. This is especially useful if you want to do numeric sorting on an alphanumeric field. This can be done using the syntax below:
data-type='number'?>

The sort XMLP directive should immediately follow the XMLP for-each directive

E.g.