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.