本帖最后由 newstong 于 2015-7-2 10:27 编辑
数据如下:
with t as (
select '01' lbid,'商吕001' spmc from dual union all
select '01' lbid,'商吕002' spmc from dual union all
select '01' lbid,'商吕003' spmc from dual union all
select '02' lbid,'商吕004' spmc from dual union all
select '02' lbid,'商吕005' spmc from dual union all
select '02' lbid,'商吕006' spmc from dual union all
select '02' lbid,'商吕007' spmc from dual union all
select '02' lbid,'商吕008' spmc from dual union all
select '02' lbid,'商吕009' spmc from dual union all
select '02' lbid,'商吕010' spmc from dual union all
select '02' lbid,'商吕011' spmc from dual union all
select '03' lbid,'商吕012' spmc from dual union all
select '03' lbid,'商吕013' spmc from dual union all
select '04' lbid,'商吕014' spmc from dual union all
select '04' lbid,'商吕015' spmc from dual union all
select '04' lbid,'商吕016' spmc from dual union all
select '04' lbid,'商吕017' spmc from dual union all
select '04' lbid,'商吕018' spmc from dual union all
select '04' lbid,'商吕019' spmc from dual union all
select '04' lbid,'商吕020' spmc from dual union all
select '04' lbid,'商吕021' spmc from dual
) select lbid,spmc from t
LBID
|