ORDER BY TWO COLUMNS IF RESULT IS REQUL CONSIDER ANOTHER COLOUMN : am having a table called marks. total_marks and aggregate . iwant to sort the results first depending on the aggregate .but when the aggregate in the same colom is equal to the next the consider the student with the highest total ie oder by agregate bu if the last aggregate is equal to the new one then give the highest rank to the one wiith higher total