I currently have a table already in production that would like to add a sort to (GROUP BY field ASC). The table currently is just sorted by the PK in an ascending order. i would like to sort on another field.
The table is used as a backend storage for a web app. So by the sorting the table on the backend, I would like the usernames sorted on the front end web app.