Summarize multiple Column values into one row

• TecheeGirl

  SSChasing Mays

  Points: 604

  More actions

  February 18, 2009 at 5:32 pm

  #383967

  I have a table

  Col1 Col2 Col3 Col4 Col5

  ----- ------ ------ ----- ------

  1 abc NULL NULL NULL

  1 NULL def NULL NULL

  1 NULL NULL ghi NULL

  1 NULL NULL NULL jkl

  I want:

  Col1 Col2 Col3 Col4 Col5

  ----- ------ ------ ----- ------

  1 abc def ghi jkl

  At first I thougt I could use pivot which I'm not sure how to do that but then I started doubting that. Any help would be great!

  Thanks~!

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  February 19, 2009 at 1:23 am

  #946499

  something like

  select col1,max(col2),max(col3)... from table

  group by col1

  ---

  Madhivanan

  Failing to plan is Planning to fail