Originally posted by dba_akram
I dont think it is a good practice to have columns selected more than once as well as to use position number for ordering the result. If there is any change in the program unit, the developer has to modify the order by position number at all locations of order by clause. Moderators please advice on this.
ok!
Second variant:

put the SQL in a SUBSQL ordering the named coloumn outside

SELECT column1, column2, ... from ( SELECT ....
)
ORDER BY columnx