select a.类型1,b.类型2 from
(
select 类型1,min(类型2) as 类型2
from test
group by 类型1
)a
,test b
where a.类型2(+) = b.类型2 and a.类型1(+) = b.类型1
order by 序号
(
select 类型1,min(类型2) as 类型2
from test
group by 类型1
)a
,test b
where a.类型2(+) = b.类型2 and a.类型1(+) = b.类型1
order by 序号
她那个语句最后可以order by 类型1
谢谢各位啦
(
select 类型1,min(类型2) as 类型2
from test
group by 类型1
)a
,test b
where a.类型2(+) = b.类型2 and a.类型1(+) = b.类型1
order by b.类型1这样应该可以吧?!