Steve Steve - 1 year ago 85
SQL Question

iPhone SQLite tracking scores in a table

I have an sqlite table in my game that keeps track of scores. How do I make one of the columns track scores in ascending order instead of descending order?

Answer Source

The order of the data in the table itself is irrelevant, it's how you order it when retrieving it via a query is what matters.

In that case, in your SQL select statement, you can add the clause ORDER BY "column_name" ASC where column_name is the column you want to order by.