FGDB SQL — Multiple columns on the left-hand side of the IN operator

Bud — Thu, 04 Apr 2024 19:49:35 GMT

ArcGIS Pro 3.2.1; file geodatabase

In a mobile geodatabase (and Oracle and Postgres), I can use a SQL expression in Select By Attributes like this:

(t_species, t_date) IN (
  SELECT 
    t_species, 
    max(t_date) 
  FROM 
    species_records 
  GROUP BY 
    t_species
)

That's a simple and efficient way to select the greatest 1 per group (with ties).

That technique can be described as: "using a row value (multiple columns) on the left-hand side of the IN operator".

Could FGDB SQL be enhanced to support that syntax?

idea FGDB SQL — Multiple columns on the left-hand side of the IN operator in ArcGIS Pro Ideas