How can we use order by in SQLite

Question

There is two field in my data base id(primary key) and name. I want arrange my data in descending order by using id

Answer 1

SELECT * FROM your_table ORDER BY id DESC;

Answer 2

    SELECT [column(s)]
      FROM [table]
  ORDER BY [column(s)] [ASC, DESC];

For more information check here: http://www.sqlite.org/lang_select.html

Answer 3

SQL has an ORDER BY clause that allows you do order the result set by any column/columns, ascending and descending.

For your particular question:

SELECT Id, Name
FROM myTable
ORDER BY Id DESC;

See this SO question (SQLite - sorting a table).