|
楼主
发表于: 2009-08-04 16:33:11
|
|
楼主
发表于: 2009-08-04 16:33:11
|
max
(fruitname),
','
)fruitname
from
(
(
a.*,row_number()over(partition
price)rn
aaaa
price>=3)
start
with
rn=1
connect
country=
prior
country
and
rn-1=
rn)
country
COUNTRY FRUITNAME
china orange,banana
japan cherry
(*)=2
@H_144_1404@
|