I have this query which works:
我有这样一个查询:
SELECT id, SUM(points) AS points
FROM leaderboard
WHERE roundtime BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP
GROUP BY id ORDER BY points DESC LIMIT 25
SE
阅读背景：
在查询结果中使用用户名替换id外键。
来源：互联网
分享到：
