BigMemory 4.3.7 | Product Documentation | BigMemory 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