How can we fetch top 3 data value from database

Question

There is three field in my data base id(primary key),name, salary I want fetch top 3 salary from the database.

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).

Answer 4

Use LIMIT to get top 3 after ordering, as such:

SELECT *
FROM myTable
ORDER BY salary DESC
LIMIT 3;