PostgreSQL 分组

select site_planning_id,superior_site_planning_id from
(SELECT row_number() OVER (PARTITION BY a.规划_共模站点id ORDER BY a.规划_共模站点id, a.begin_time DESC) AS rn, nm.npa_site_planning_id as site_planning_id
from
mtnoh.TB_规划_AAA_规划站点_共模 a
) tmp where tmp.rn=1;