3 replies

[sqlite] How to order by rowid?

Having a query like:

db.query.countryTable.findAll({
    where: eq(countryTable.continentId, continentId),
    orderBy: // how to order by rowid  
})

db.query.countryTable.findAll({
    where: eq(countryTable.continentId, continentId),
    orderBy: // how to order by rowid  
})

I would like to order by the sqlite rowid.

Maybe in this example it would make more sense to order by the country name, but this just for an example.
In my case I have no natural column to order by, but want to sort on rowid.

[sqlite] How to order by rowid?

Similar Threads

[sqlite] How to order by rowid?

Similar Threads

Similar Threads

Similar Threads