I have a table with 20 columns and I have to retrieve 19 except one. Is there any way easier then giving SELECT Col1,Col2,Col3,..........Col19 from table1.

dan

• Jul 31st, 2015

No, cant be done.

bhanu

• Nov 23rd, 2011

If we are dong select top 33* from table, we will get topmost 33 records but not the all 33 columns except 1 column in a table.

Answer Question  Select Best Answer