How to get first top row of the table in Sqlite via Sql Query

Question

I need to fetch the first top row of a table in a Sqlite database    But my program throws an SQLException  Sqlite Syntax Error  Syntax error near  1    for the query that I am using   SELECT TOP 1    FROM SAMPLE TABLE   That I guess is a syntax particularly for MS SQL SERVER and MS ACCESS  Right now I am using   SELECT   FROM SAMPLE TABLE LIMIT 1   What is the best solution for this problem

User · Answer

LIMIT 1 is what you want   Just keep in mind this returns the first record in the result set regardless of order  unless you specify an order clause in an outer query

User · Answer

Use the following query   SELECT   FROM SAMPLE TABLE ORDER BY ROWID ASC LIMIT 1   Note  Sqlite s row id references are detailed here

[sql] How to get first/top row of the table in Sqlite via Sql Query

Examples related to sql

Examples related to sqlite