17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT T3.COL1, T3.COL2, T3.COL3, T3.COL4
FROM (SELECT T.*,
ROW_NUMBER() OVER(PARTITION BY T.COL2, T.COL4 ORDER BY T.COL1) AS RN
FROM TABLE1 T
INNER JOIN (SELECT DISTINCT S.COL2, S.COL4
FROM TABLE1 S
WHERE S.COL4 < 0) T2
ON T.COL2 = T2.COL2
AND T.COL4 = -T2.COL4) T3
WHERE T3.RN = 1