BigMemory Go 4.3.1 | Product Documentation | BigMemory Go 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 - 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release