暂无个人介绍
2020年01月
33
SELECT shipid, paydate, payno
FROM (
SELECT *,
row_number() OVER (PARTITION BY shipid ORDER BY paydate) AS rn_dt,
row_number() OVER (PARTITION BY shipid ORDER BY payno) AS rn_no
FROM orders
)
WHERE rn_dt = 1
AND rn_no = 1