Product Documentation : Big Memory Max Developer Guide : Searching with BigMemory SQL : SQL Syntax and Examples : ORDER BY Clause
ORDER BY Clause
To order the Query results, add an ORDER BY clause.
The general form of the ORDER BY clause is:
order by <attribute 1> <asc[ending] | desc[ending]>,
<attribute 2> <asc[ending] | desc[ending]>, . . .
<attribute n> <asc[ending] | desc[ending]>
The default ordering direction is ascending.
ORDER BY Examples
select * from Person where age > 30 order by age asc, name desc
select age from Person where ((age > 100 and zip=20144) or time > 10)
order by age descending
select age, zip from Person where ((age > 100 and zip=20144) or time > 10)
order by age desc, zip asc
Copyright © 2010-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback