Need to show a SQLite query in descending order
I want to make a query such that the result will be shown in
indistinct descending order.
For example, assume column ID has six rows. I need an query that shows me the list of IDs
indistinct descending from 6 to 1.
EDIT: Based on the first post’s text, the question is how do display query results in descending order. For instance, given the IDs
ID -- 1 2 3 4 5 6
ID -- 6 5 4 3 2 1
2 Solutions collect form web for “Need to show a SQLite query in descending order”
You need to add an
ORDER BY ID DESC to your select statement.
Use following statement….
select * from YOUR_TABLE_NAME ORDER BY ID DESC;