mercredi 16 septembre 2015

ORMLite search for rows with most common column

I'm using ORMLite for working with local database and have an issue with one custom query.

I need to get one row which's some column's value is most common in table.

E.g. I have a column text and I have 3 rows with value text0, 4 rows with value text1 and 5 rows with value text2. I need to get one of the rows which have value text2 of text column.

Can I do this with ORMLite's query builder or I should run a raw query?

Aucun commentaire:

Enregistrer un commentaire