How to get Top 5 records in SqLite?

sqlite select
Amitabh picture Amitabh · Apr 28, 2010 · Viewed 224.3k times · Source

I have tried this which did not work.

select top 5 * from [Table_Name]

Answer

Nix picture Nix · Apr 28, 2010 
SELECT * FROM Table_Name LIMIT 5;

Related questions

SQLite select where empty?

In SQLite, how can I select records where some_column is empty? Empty counts as both NULL and "".

Read More
sql, order by column A and then by column B

How to write the sql so that the result can be ordered first by column A than by column B. Something like below: SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B

Read More
SQLite: bind list of values to "WHERE col IN ( :PRM )"

all I want to do is send a query like SELECT * FROM table WHERE col IN (110, 130, 90); So I prepared the following statement SELECT * FROM table WHERE col IN (:LST); Then I use sqlite_bind_text(stmt, 1, "110, 130, 90", -1, SQLITE_STATIC); Unfortunately …

Read More