Select a specific index row in sqlite

Question

I have an index and I need to find out what is the row in a table with that index, in SQLite. Example:

Index = 1

Table:

ID   -    Name
aa1      John
aa2      Mark   <-- I need this row
aa3      Lucy
aa4      Jim 

Which is the correct SELECT that I can use to solve my problem?

Answer 1

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.