PGSQL分组查询的6种方式 分组查询方式 1、with-row_number() 2、row_number() 3*、distinct on() 4*、with-lateral 5*、parentTable-lateral 6、array_agg()-group by 性能比较 分组查询方式 下面整理了6种查询方式,根据实际使用场景选择适合的查询方式。 1、with-row_number() WITH res AS ( SELECT id, name, code, range_code, ROW_NUMBER() OVER(PARTITION BY range_code ORDER BY code) AS rowid FROM base.d_range_value ) SELECT * FROM res WHERE rowid=1 2、row_number() select * from ( select id, name, code