sqlite: How to select duplicate keys

mercredi 6 avril 2016

My SQLite table tPeople has a primary key on field fLocation of UNSIGNED INTEGER (which is not the rowid).

It also has a secondary index on field fLastName of TEXT which is filled with last names - and it naturally has lots of duplicate keys.

Let's say my display can handle 500 rows at a time so I...

SELECT * FROM tpeople WHERE fLastName = 'Smith' LIMIT 500

...but there could be 2,600 fLastNames equal to 'Smith' or maybe just 3 of them.

How do I select the next 500 rows with fLastName = 'Smith'?

sqlite