Merge two rows in a query

0

I have my query that shows me my data in this way

select
   Nombre,
   Deporte,
   sum(Ganar),
   sum(perder)

from Tabla  
where   CodPersona = 777
group by  Nombre, deporte

the query shows me the sums of the two sports and repeats the results for both the same value

What I should show would be like this

    
asked by 24.05.2018 в 20:46
source

0 answers