请教如何书写这样的SQL语句

[NorthStar21]

有table数据如下

name value
a 3
b 2
c 1

我想查询出的结果，按value复制成多行，如下：

name level
a 1
a 2
a 3
b 1
b 2
c 1

求教。。。。

[sych888]

select a.nn,b.ll from test1 a,(select level ll from dual connect by level<4) b where b.ll<=a.id order by a.nn;

[kongxv0001]

引用 2 楼 sych888 的回复:

select a.nn,b.ll from test1 a,(select level ll from dual connect by level<4) b where b.ll<=a.id order by a.nn;

引用 1 楼 u010412956 的回复:

select distinct name, level from t connect by level <= value order by name;

测试了下，两个都可以用。不过不太明白，这个connect by level 是怎么回事？能麻烦给讲讲吗？

[u010412956]

引用 3 楼 kongxv0001 的回复:

引用 2 楼 sych888 的回复:select a.nn,b.ll from test1 a,(select level ll from dual connect by level<4) b where b.ll<=a.id order by a.nn; 引用 1 楼 u010412956 的回复:select distinct name, level f……

oracle的层次查询 http://www.cnblogs.com/lettoo/archive/2010/08/03/1791239.html

[u010412956]

select distinct name, level from t connect by level <= value order by name;