Help Sorting Order of Tables in SQL
Hello, I was wondering if anyone knew how I could order the table in my database by the scores while also keeping a 1-60 order with the id numbers?
Like when I insert an entry if the score is higher than the others I want it to be inserted at the top with the id number 1.
Right now when I insert a value and the score is higher it just goes on the end with an id of 61.
I have the ids set up to auto-increment. But I need the order to be highest to lowest score as well.
Anyone know how to make this happen?
Subject
Written By
Posted
Help Sorting Order of Tables in SQL
March 25, 2021 09:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.