mercredi 24 février 2016

Select max of colA in each colB using group by in sqlite

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