|
在超级复杂栏次透视表有一段SQL语句
select 职级, 最高学历, "合计" as 分类 from [花名册$] union all
select 职级, 最高学历, "学历" as 分类 from [花名册$] union all
select 职级, 年龄, "年龄" as 分类 from [花名册$] union all
select 职级, 学位, " " as 分类 from [花名册$] union all
select 职级, 性别, " " as 分类 from [花名册$] union all
select 职级, 民族, " " as 分类 from [花名册$] union all
select 职级, 政治面貌, " " as 分类 from [花名册$]
最终组成了三个字段 职级 最高学历 分类
如把第一行“职级, 最高学历, "合计" ”改为“职级, 年龄, "年龄" ”则组成了三个字段 职级,年龄,分类三个字段。字段是以第一行中字段来命名的。其中第一列 职级 字段只有职级值如正厅、副厅等,第二列最高学历却包含年龄、学位、性别、民族、政治面貌的值,分类只有“合计”、“学历”、“年龄”。这样就为重新组合新字段提供了一种方法
同理,想要四个字段 职级 最高学历 政治面貌 分类 可以这样做
select 职级,最高学历,政治面貌,"合计" as 分类 from [花名册$] union all
select 职级,最高学历,性别,"学历" as 分类 from [花名册$] union all
select 职级,年龄,学位,"年龄" as 分类 from [花名册$] union all
select 职级,学位,学位," " as 分类 from [花名册$] union all
select 职级,性别,学位," " as 分类 from [花名册$] union all
select 职级,民族,政治面貌," " as 分类 from [花名册$] union all
select 职级,政治面貌,民族," " as 分类 from [花名册$] 即可但对应的数据类型要相同
申明:本人不会SQL。是否正确,请指教,请大家棒场,谢谢!!
[ 本帖最后由 cq418854188 于 2009-3-19 10:29 编辑 ] |
|