declare @sql varchar(8000),@i int
select @i=0,@sql = 'select '
select @i=@i+1,@sql=@sql+''''+aa+''' as aa'+cast(@i as varchar)+',' from 表 group by aa
select @sql=substring(@sql,1,len(@sql)-1)
exec(@sql)
declare varchar a
declare varchar b
declare varchar c
set a=(seletct table1.aa where tatble1.aa=1)
set b =(seletct table1.aa where tatble1.aa=2)
set c=(seletct table1.aa where tatble1.aa=3)
insert into tatble values(a,b,c)
update b set b.a1 = (select top 1 a.aa from a order by a.aa),b.a3 = (select top 1 a.aa from a order by a.aa desc),b.a2 = select top 1 s from(selct top 2 a.aa as s from a order by a.aa desc )