求高手一条SQL语句,列转行的问题,可能需要分析函数!
col1(id) col2 col3
a 1 3
b 2 5
能不能用一句SQL来实现下面结果
a 1
a 2
a 3
b 2
b 3
b 4
b 5
谢谢啦
[解决办法]
很简单的层次查询
with t as
(select 'a' col1, 1 col2, 3 col3
from dual
union all
select 'b', 2, 5
from dual
union all
select 'c', 9, 33 from dual)
select distinct col1, col2 + level - 1
from t
connect by level <= col3 - col2 + 1
order by col1;