select *
from (
select fieldname as col1 from tablename where fieldname like 'A%'
) as a,(
select fieldname as col2 from tablename where fieldname like 'B%'
) as b,(
select fieldname as col3 from tablename where fieldname like 'C%'
) as c,(
select fieldname as col4 from tablename where fieldname like 'D%'
) as d
from (
select fieldname as col1 from tablename where fieldname like 'A%'
) as a,(
select fieldname as col2 from tablename where fieldname like 'B%'
) as b,(
select fieldname as col3 from tablename where fieldname like 'C%'
) as c,(
select fieldname as col4 from tablename where fieldname like 'D%'
) as d
第一列 第二列 第三列
AA BB BB
即所有组合后的记录都赋予上面的列值。
from (
select fieldname as col1 from tablename where fieldname like 'A%'
) as a,(
select fieldname as col2 from tablename where fieldname like 'B%'
) as b,(
select fieldname as col3 from tablename where fieldname like 'C%'
) as c,(
select fieldname as col4 from tablename where fieldname like 'D%'
) as d