对相关记录进行分组，但仅从第一条记录中选择某些字段

I'm preforming an aggregate function on multiple records, which are grouped by a common ID. The problem is, I also want to export some other fields, which might be different within the grouped records, but I want to get those certain fields from one of the records (the first one, according to the query's ORDER BY).I'm preforming an aggregate function on multipl