I have a table with a similar structure to this:
Index - AutoInc field
UserId - integer
Amount - integer
This is an audit type report where each UserID will have more than one record. I need to produce a report showing totals per UserID with the UserID with the highest total appearing frst in the report and then decsending to the dude with the lowest.
Is this possible WITHOUT having to pre-process the data ?