SQLite3 and limiting the number of results

Question

Is there a clean way to limit the number of hits from a SQLite3 statement SELECT?

For example, I can request using SELECT * FROM myTable WHERE name='Smith';, realizing that I can run into thousands of hits. I would like SQLite3 to let me say the first 10 that it meets, and then complete the query. How to do it?

If SQLite3 does not provide this immediately, is there anything I can edit in the SQLite3 source code from which I can rebuild?

Suppose I am in an environment where I have only one thread, and I would like to return in a reasonable time.

Answer 1

LIMIT:

SELECT * FROM myTable WHERE name='Smith' LIMIT 10

Answer 2

SELECT: LIMIT:

select * from sometable where .... limit 10;

OFFSET , . ( ORDER BY, .)

Answer 3

SQLite docs:

LIMIT , SELECT. LIMIT, , . NULL , , . LIMIT , . SELECT N , N - , LIMIT. , SELECT N LIMIT, .