How to get Top 5 records in SqLite ?

Question

I have tried this which did not work.

select top 5 * from [Table_Name]

Answer 1

  SELECT * FROM Table_Name LIMIT 5;

Answer 2

select * from [Table_Name] limit 5

Answer 3

An equivalent statement would be

select * from [TableName] limit 5

http://www.w3schools.com/sql/sql_top.asp

Answer 4

TOP and square brackets are specific to Transact-SQL. In ANSI SQL one uses LIMIT and backticks (`).

select * from `Table_Name` LIMIT 5;