mardi 26 janvier 2016

SQLite limit different column than order results

Let's say I have a table of a few hundred names and ages. I want to query the 100 youngest people like

SELECT name, age FROM people ORDER BY age ASC LIMIT 100

But what if I wanted the results to come back sorted by name? Is there an easy way to do that?

Aucun commentaire:

Enregistrer un commentaire