Column to return 2 rows

• mmatseke

  Ten Centuries

  Points: 1129

  More actions

  October 27, 2004 at 12:59 pm

  #60429

  Good day!

  I have the following table

  Table1

  Col1    Col2

  10        INP

  22        OVL

  23        INP

  26        OVL

  28        INP

  I want my output to put all INP's in once column and all OVL in another, please help with select syntax

  Col1    Col2    Col3

  10      INP

  22                 OVL

  23      INP

  26                 OVL

  28      INP

• dongadoy

  SSC Eights!

  Points: 880

  More actions

  October 27, 2004 at 1:27 pm

  #528208

  select

  col1,

  col2 = case col2 when 'INP' then col2 end,

  col3 = case col2 when 'OVL' then col2 end

  from Table1