PostgreSQL：同一表中每个项目的前n个条目

PostgreSQL：同一表中每个项目的前n个条目

SELECt * FROM (
SELECt uid,
title,
amount,
maker,
widgets,
rank() over (partition by maker order by amount desc) as rank
FROM entry
) t
WHERe rank <= 3