Pivot

• MexiCano

  SSC Enthusiast

  Points: 149

  More actions

  August 12, 2004 at 4:25 pm

  #108580

  hi all,

  i have many hours with this problem, but i hope that you can help me to solve.

  this is the table

  cverut   Ene       Feb 

  301     677.0      0.0

  301     0.0         577.0

  301     0.0         0.0

  302     454.0      0.0

  302     0.0         484.0

  302     0.0         0.0

  303     676.0      0.0

  303     0.0         976.0

  303     0.0         0.0

  i need  this result:

  cverut    Ene    Feb

  301     677.0     577.0

  302     454.0     484.0

  303     676.0      976.0

  thanks

• Nilssond

  Hall of Fame

  Points: 3285

  More actions

  August 12, 2004 at 5:12 pm

  #518783

  SELECT CVERUT, SUM(ENE) AS ENE, SUM(FEB) AS FEB  FROM TABLE GROUP BY CVERUT

• MexiCano

  SSC Enthusiast

  Points: 149

  More actions

  August 12, 2004 at 5:24 pm

  #518784

  thanks Nilssond

  your solution is perfect and easy