PGSQL语句：多条数据，根据某一相同值字段，获取一条数据

问题：表关联查询，但是我只需要其中任意一条数据即可

分组

SELECT
		*,
		ROW_NUMBER ( ) OVER ( PARTITION BY crm_serve_repair.ID ORDER BY crm_serve_repair.ID ) AS group_idx 
	FROM
		crm_serve_repair
		LEFT JOIN crm_repair_site ON crm_serve_repair.ID = crm_repair_site.
		ID LEFT JOIN crm_site ON crm_repair_site.site_id = crm_site.
		ID LEFT JOIN crm_repair_customer ON crm_serve_repair.ID = crm_repair_customer.
		ID LEFT JOIN company_info ON crm_repair_customer.customer_id = company_info.company_key 
	WHERE
		company_info.company_name LIKE'%临沂中石油昆仑燃气有限公司%' 

效果：

最后

SELECT
	s.* 
FROM
	(
	SELECT
		*,
		ROW_NUMBER ( ) OVER ( PARTITION BY crm_serve_repair.ID ORDER BY crm_serve_repair.ID ) AS group_idx 
	FROM
		crm_serve_repair
		LEFT JOIN crm_repair_site ON crm_serve_repair.ID = crm_repair_site.
		ID LEFT JOIN crm_site ON crm_repair_site.site_id = crm_site.
		ID LEFT JOIN crm_repair_customer ON crm_serve_repair.ID = crm_repair_customer.
		ID LEFT JOIN company_info ON crm_repair_customer.customer_id = company_info.company_key 
	WHERE
		company_info.company_name LIKE'%临沂中石油昆仑燃气有限公司%' 
	) s 
WHERE
	s.group_idx = 1

效果图：