17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM (SELECT key,
userid,
row_number() over(PARTITION BY userid ORDER BY amendtime) rn,
amendtime,
status,
pid
FROM USER
WHERE status = 1 AND
pid = 12)
WHERE rn = 1;
SELECT *
FROM (SELECT key,
userid,
row_number() over(PARTITION BY userid ORDER BY amendtime) rn,
amendtime,
status,
pid
FROM USER)
WHERE rn = 1;