mardi 27 octobre 2015

SQLite select most common

The table is look like:

A,B
----------
John,a
John,a
Peter,a
Mary,b
Ann,b
Ann,b

I want the result is group by B and select the most common word from A:

A,B
----------
John,a
Ann,b

Thank you.

Aucun commentaire:

Enregistrer un commentaire