An order by clause in SQL specifies that a SQL select statement returns a result set with the rows being sorted by the values of one or more columns.

Attributes

Name	Description	Value
field	A table field.	Any field name
sortorder	Defines the sorting order of the data.	ASC or DESC

Example

Order By

Order By

	<orderby>
		<fielditem>
			<field>OUGROUPS.OUGNAME</field>        
			<sortorder>ASC</sortorder>   
		</fielditem>
	</orderby>