ROWS TO MYSQL COLUMNS

0

Hi, I have been researching and unfortunately it is not so clear to me to be able to move from rows to columns or maybe it does not have the same format as in the examples I'm doing this query to enter it into a KENDO GRID table, This is my query:

SELECT ANO AS YEAR,
    SUM(VENTAS) VENTAS,
    SUM(DEVOLUCIONES)   DEVOLUCIONES,
    SUM(TOTALI) TOTALI, 
    (((SUM(VENTAS)/SUM(TOTALI)))*100) VERTIALVENTAS,
    ((SUM(VENTAS))/(SELECT   SUM(VENTAS) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALVENTAS, 
    ((SUM(DEVOLUCIONES)/SUM(TOTALI)))*100) VERTIALDEVOLUCIONES, 
    ((SUM(DEVOLUCIONES))/(SELECT SUM(DEVOLUCIONES) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALDEVOLUCIONES, 
    (((SUM(TOTALI)/SUM(TOTALI)))*100) VERTIALTOTALI, 
    ((SUM(TOTALI))/(SELECT SUM(TOTALI) FROM EDORESULTADO WHERE ANO=YEAR-1)-1)*100 HORIZONTALTOTALI 
FROM EDORESULTADO 
GROUP BY ANO

I tried to do it but I could only get this and then I do not know what to do anymore. GREETINGS

SELECT 
    SUM(CASE WHEN ANO="2012" THEN VENTAS ELSE 0 END) "2012",
    SUM(CASE WHEN ANO="2013" THEN VENTAS ELSE 0 END) "2013",
    SUM(CASE WHEN ANO="2014" THEN VENTAS ELSE 0 END) "2014",
    SUM(CASE WHEN ANO="2015" THEN VENTAS ELSE 0 END) "2015",
    SUM(CASE WHEN ANO="2016" THEN VENTAS ELSE 0 END) "2016",
    SUM(CASE WHEN ANO="2017" THEN VENTAS ELSE 0 END) "2017",
    SUM(CASE WHEN ANO="2018" THEN VENTAS ELSE 0 END) "2018"
FROM EDORESULTADO 

    
asked by ANDRES PALMA HERNANDEZ 30.10.2018 в 08:13
source

0 answers