Skip to end of banner
Go to start of banner

Order By

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Order By

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

NameDescriptionValue
fieldA table field.Any field name
sortorderDefines the sorting order of the data.ASC or DESC

Example

 Order By
Group By
...
 
	<orderby>
		<field>
		<field>OUGROUPS.OUGNAME</field>        
		<sortorder>ASC</sortorder>   
		</field>
	</orderby>
 
...
  • No labels