只需将您的聚合添加到子查询中并加入它即可：
SELECt a.ID, sub.Poss_Phone, CELL_FLAGFROM TableA as aINNER JOIN (SELECt ID, MAX(POSS_PHONE) as [Poss_Phone] FROM TableA GROUP BY ID) Sub ON Sub.ID = a.ID and SUB.Poss_Phone = A.Poss_Phone
这将保持未聚合字段之间的完整性，但仍会给您
MAX(Poss_Phone)per
ID。
