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