Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]

You seem to want aggregation:

select disport, actualagent, . . . , country,
       sum(pallats), sum(gross)
from t
group by disport, actualagent, . . ., country;

You need to list all the columns where the . . . is.