I have a table in sqlite. I am trying to get the max of ColA of each ColB.
My table looks like this:
select * from table1
ColA | ColB
63.9 1234
9.09 1234
52 1678
8.65 1678
7.07 0987
54 0987
23 9876
I would like to query the max of ColA from each ColB. And the output expected is :
MaxofColA | ColB
63.9 1234
52 1678
54 0987
23 9876
I need the sqlite query for this?
Aucun commentaire:
Enregistrer un commentaire