mardi 1 septembre 2015

SQLite and range query

How could I perform a simple range querry in SQLite efficiently?

Say, I have data that saves person information and I want to find the people with age between 20~45, and weight between 50~80kg?

What should I do (like setting certain index?) to make the searching more efficient?

Aucun commentaire:

Enregistrer un commentaire