|
楼主 |
发表于 2011-12-20 14:50
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
魂断蓝桥 发表于 2011-12-20 10:22
select * from (select "一号楼" as 楼号,* from [一号楼$b2:k] union all
select "二号楼",* from [二号楼 ...
谢谢你的帮助!
再请教:
select "一号楼",* from [一号楼$b2:k] union allselect "二号楼",* from [二号楼$b2:k] union allselect "三号楼",* from [三号楼$b2:k]) where 部门 is not null and 房间类型 is not null(我模仿你的编的)
select * from (select "一号楼" as 楼号,* from [一号楼$b2:k] union allselect "二号楼",* from [二号楼$b2:k] union allselect "三号楼",* from [三号楼$b2:k] )where 部门 is not null and 房间类型 is not null(你编的)
以上这两个SQL语名都同样可以作出透视表来,但两语句前部分编写略有不同,请问有何区别??随便问下语用的意思是什么?尤其是英文部份的意思?
不甚感激跪求!! |
|