Re: [sqlite] How to return only certain number of rows from a table in a select statement and not all the rows

[Steve Frierdich]

Thanks  Bert

Bert Verhees wrote:

Steve Frierdich wrote:

Does anyone know what I need to add to a select statement so only certain number of rows will return?
What would I add to a select statement query so only 10 rows from a table would return and not all the records in the table.
Thanks
Steve

select * from table LIMIT 10