Hi, I need your help because I would like to show in this table the program for each country which has the maximum value. Only one program (with the maximum value) for each country.
Hi @giad,
you can first use group by to determine the max activity for each country. In a second step you join these results to your inital table using inner join method and as key columns country and activity or rather max(activity).