3,491
社区成员
发帖
与我相关
我的任务
分享
SELECT m.*
FROM (SELECT t.*,
ROW_NUMBER() OVER(PARTITION BY t.tradeid ORDER BY t.paydate) rn,
COUNT(DISTINCT t.paydate) OVER(PARTITION BY t.tradeid) cnt
FROM t) m
WHERE m.rn = 1
AND m.cnt > 1