Hi Joshua, Thanks for this clear explanation. I guess my simple query worked on a simple dataset purely by chance because the ELEVATIONS were floats so were unique figures just by chance. For this dataset, the elevations are integers so were less likely to be unique. I was just wondering how exactly to implement your SQL into a definition query in Arcmap? I tried this: [OBJECTID] IN ( SELECT [OBJECTID] FROM NW_US_mountains_intersect t1, (SELECT [FID_T25km_grid_washington_IDAHO_MONTANA], MAX([ELEVATION]) as maxe FROM NW_US_mountains_intersect GROUP BY [FID_T25km_grid_washington_IDAHO_MONTANA] t2 WHERE t1.[FID_T25km_grid_washington_IDAHO_MONTANA] = t2.FID_T25km_grid_washington_IDAHO_MONTANA] AND t1.[ELEVATION] = t2.maxe) Thanks! Garret
... View more