区别 在MySQL中分页主要依赖关键字GROUP BY,其中参数代表根据一个或多个字段已经分组。 在PostgreSQL中分页关键字也是PARTITION BY 需求 按字段组合查询记录大于1的数据(查询出重复的数据): 代码示例 -- MySQL SELECT id, count(*) as count FROM table group by username having count > 1; -- PgSQl SELECT id FROM ( SELECT id, username, ROW_NUMBER() OVER (PARTITION BY username ORDER BY username) AS row_num FROM TABLE ) AS subquery WHERE row_num > 1;