Sort a table without using an open listbox?

General
1

What I am trying to do is to sort a table in an SQLite database in descending order and then do something which the highest, second highest, third highest, etc, values of each column.
I don’t want to use an open ListBox (one that the user will see) so is there a way of sorting without showing a visible listbox?
Ultimately I want to give points which is a value in the listbox to the records with the highest values for each column.
If there’s a more efficient way of what I would like to do, please do say. Likewise, if you don’t understand what I’m trying to do please ask.

Thank you!

2

No need for a listbox!

http://www.w3schools.com/sql/sql_orderby.asp

3

[quote=156244:@Ashot Khachatryan]No need for a listbox!

http://www.w3schools.com/sql/sql_orderby.asp[/quote]

Oh, of course. I’ve used ORDER BY before so I don’t know why I didn’t think of it.
I’ll give it a go thanks!

Edit: I’m stumped on how to find the record number. So for example the first record will have this: record.Field("Points").IntegerValue=record.Field("Points").IntegerValue+10