Sorting records by using the BY phrase
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
As you've seen, you can sort the records by using the BY phrase.
The default is ascending order, but you cannot use the keyword ASCENDING to
indicate this. You'll get a syntax error, so just leave it out to
get ascending order.
To sort in descending order, add the keyword DESCENDING to
the BY phrase:
|
To sort on multiple fields, you can repeat the BY phrase.