Convert row into column

• rukmang rege

  SSC Enthusiast

  Points: 107

  More actions

  April 5, 2007 at 12:30 am

  #175778

  select *  from table1

  1

  2

  3

  4

  Can I write a single query(no block) to give me o/p as 1,2,3,4.

   

   

• Vivek Phanse

  Grasshopper

  Points: 15

  More actions

  April 5, 2007 at 12:42 am

  #698722

  http://www.sqlteam.com/item.asp?ItemID=2368

• [KH]

  SSCommitted

  Points: 1908

  More actions

  April 5, 2007 at 9:49 am

  #698839

  also take a look here http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx