sql 查询 裁分

来源：百度知道 编辑：UC知道 时间：2024/05/27 14:49:47
如果我有 一张表

(如果)为

bianhao yuangong yuangong1 yuangong2 yuangong3
0078 xiaoqian qiangxiao huangxiao zhangzhang
0079 xiaoqian1 qiangxiao2 huangxiao3 zhangzhang4
怎么(查询)成
bianhao yuangong
0078 xiaoqiang
0078 qiangxiao
0078 huangxiao
0078 zhangzhang
0079 xiaoqian1
0079 qiangxiao2
0079 huangxiao3
0079 zhangzhang4
audiotech
你能详细讲解下嘛
经过测试只有你的能用
讲解下在追加20分
其他人注意题目- -！不看清楚都乱来
xuechen1981 送你一句话别蔑视别人的方法
说不定有大用处呢 什么都按第3范式来那么你无救了
我发现还有使用别名的方式来达到目的

SELECT BIANHAO, YUANGONG FROM TABLENAME
UNION ALL
SELECT BIANHAO, YUANGONG1 FROM TABLENAME
UNION ALL
SELECT BIANHAO, YUANGONG2 FROM TABLENAME
UNION ALL
SELECT BIANHAO, YUANGONG3 FROM TABLENAME
ORDER BY BIANHAO

经过测试可以用

下面这个也是差不多 只是在用系统表 如果你是DB2的系统可以直接复制粘贴就可以跑了
select '0078' AS BIANHAO,'xiaoqian' AS YUANGONG
from sysibm/sysdummy1
UNION ALL
select '0078' AS BIANHAO,'qiangxiao' AS YUANGONG
from sysibm/sysdummy1
UNION ALL
select '0078' AS BIANHAO,'huangxiao' AS YUANGONG
from sysibm/sysdummy1
UNION ALL
select '0079' AS BIANHAO,'xiaoqian' AS YUANGONG
from sysibm/sysdummy1
UNION ALL