PGSQL分组查询的6种方式

分组查询方式

下面整理了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