SQLite Forum

Select by column id
Login
Not certain whether this answers your question, but it is perfectly valid to do a select from a table where rowid=9999

The difficulty is knowing the rowid, which may change if the table is reloaded.