How to use MAX SQL statement in ArcGIS?

المشرف العام

Administrator
طاقم الإدارة
I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field NUMBERCYLA. I am using this in an an SDE enabled geodatabase on SQL server 2008.

Here is what I have so far[UPDATE_DATE_DATE] in (SELECT max( [UPDATE_DATE_DATE] ) FROM SO_SC_1 GROUP BY [NUMBERCYLA])



أكثر...
 
أعلى