解决一网友提出的问题[@more@]代码：
select * from ttt;
T01 T02 T03
-------------------- -------------------- --------------------
1 3 4
1 5 6
已选择2行。
select distinct t01,
max(decode(t02,3,t02)) as t02,
max(decode(t03,4,t03)) as t03,
max(decode(t02,5,t02)) as t04,
max(decode(t03,6,t03)) as t05
from ttt
group by t01
T01 T02 T03 T04 T05
-------------------- -------------------- -------------------- -------------------- --------------------
1 3 4 5 6
已选择 1 行
select * from ttt;
T01 T02 T03
-------------------- -------------------- --------------------
1 3 4
1 5 6
已选择2行。
select distinct t01,
max(decode(t02,3,t02)) as t02,
max(decode(t03,4,t03)) as t03,
max(decode(t02,5,t02)) as t04,
max(decode(t03,6,t03)) as t05
from ttt
group by t01
T01 T02 T03 T04 T05
-------------------- -------------------- -------------------- -------------------- --------------------
1 3 4 5 6
已选择 1 行
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/101162/viewspace-930856/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle字符串函数（转）
下一篇：
Oracle分析函数{转}
请登录后发表评论
登录
全部评论
