https://stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group
select DISTINCT ON (creatorid) * from t
where status = '1'
ORDER BY creatorid, createtime desc
根据创建者分组,取每个创建者最早创建的记录。
https://stackoverflow.com/questions/3800551/select-first-row-in-each-group-by-group
select DISTINCT ON (creatorid) * from t
where status = '1'
ORDER BY creatorid, createtime desc
根据创建者分组,取每个创建者最早创建的记录。
转载于:https://www.cnblogs.com/goingforward/p/11410525.html