Steve Steve - 1 year ago 114
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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download