SELECT ID, TYPE, VALUE_1, VALUE_2
FROM (SELECT B.ID, A.TYPE, B.VALUE VALUE_1
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 2)
INNER JOIN (SELECT B.ID, A.TYPE, B.VALUE VALUE_2
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 3
MINUS
SELECT B.ID, A.TYPE, B.VALUE VALUE_1
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 2)
USING (ID, TYPE)
FROM (SELECT B.ID, A.TYPE, B.VALUE VALUE_1
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 2)
INNER JOIN (SELECT B.ID, A.TYPE, B.VALUE VALUE_2
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 3
MINUS
SELECT B.ID, A.TYPE, B.VALUE VALUE_1
FROM A, B
WHERE A.ID = B.ID
AND ROWNUM < 2)
USING (ID, TYPE)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货