You can use column numbers to indicate sort columns in the ORDER BY clause. This is especially helpful when sorting on calculated columns.
Eg:
Select account, ((curyear – prevyear) * 0.5) from saleshist order by 2, 1
A great place to learn RPG Free, SQL, CL programming tips and techniques
You can use column numbers to indicate sort columns in the ORDER BY clause. This is especially helpful when sorting on calculated columns.
Eg:
Select account, ((curyear – prevyear) * 0.5) from saleshist order by 2, 1