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