oracle sql 两列相加减,来自两列的最小值（Oracle SQL）

从另一个论坛得到了代码现在，对我来说工作得很好：

SELECT

tab.*

FROM

t33 tab

INNER JOIN (

SELECT

m1.y,

m1.factor1,

m1.min_1,

m2.min_2

FROM

(

SELECT

y,

factor1,

MIN(number1) AS min_1

FROM

t33 tab

GROUP BY

y,

factor1

) m1

INNER JOIN (

SELECT

y,

factor1,

number1,

MIN(number2) AS min_2

FROM

t33

GROUP BY

y,

factor1,

number1

) m2

ON m1.y = m2.y

AND m1.factor1 = m2.factor1

AND m1.min_1 = m2.number1

) sel

ON tab.y = sel.y

AND tab.factor1 = sel.factor1

AND tab.number1 = sel.min_1

AND tab.number2 = sel.min_2