SQL: selecting with column position #?

I want to use nested SELECT, but it's somewhat bothersome naming the inner columns like..

 SELECT column1, thename from (SELECT column1,

    SUM(column1) thename from t1 group by column1) ;

Is there any way to replace "thename" with something referring the column position, like COLUMN(2) ? Thanx in advance

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 19:59:58 CDT