APPX
Appendix 14 List of Available SQL Commands for CPU Module Database Access Function
1001
A
ORDER BY
This command sorts output.
■Application example
• To sort and output fld1 and fld2 of all records in ascending order of the fld1 value from table1
SELECT "fld1", "fld2" FROM "table1" ORDER BY "fld1" ASC;
Syntax
• Ascending
ORDER BY [numeric expression] ASC
• Descending
ORDER BY [numeric expression] DESC
To Next Page
Loading...
