Select a specific index row in sqlite

Typically to get a specific row you can always request them by rowid, e.g.

SELECT name FROM UnknownTable WHERE rowid = 1;

However, there are some atypical situations that preclude this. You'll really want to read up on rowids to ensure that your table is going to behave as you want.