Max no. of Columns single SELECT statement can return

• Umesh Bhavsar

  SSC Enthusiast

  Points: 167

  More actions

  December 5, 2006 at 5:08 am

  #115200

  Hello Guys,

  Can anybody help me for the following question?

  What is the value of the max no. of columns a single SELECT statement can return?

  Thanks,

  Umesh.

   

   

   

• ijaz

  SSCommitted

  Points: 1912

  More actions

  December 5, 2006 at 6:23 am

  #675802

  You can select Maximum column in a select statement are 4,096

   

   

  cheers

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  December 5, 2006 at 6:42 am

  #675815

  Holly crap, I'd like to see that statement.

   

  4096 colums from 256 tables , 10 M rows each, no index all heaps !