SELECT FIELD_ID, MAX(OBSERVATION_DATE) FROM TABLE GROUP BY FIELD_ID, OBSERVATION_DATE;
SELECT * FROM (SELECT * FROM TABLE ORDER BY OBSERVATION_DATE DESC ) table1 GROUP BY FIELD_ID ';
[FIELD_ID],[OBSERVATION_ID] IN (SELECT [FIELD_ID],[OBSERVATION_ID] FROM TABLE AS table1 GROUP BY [FIELD_ID] HAVING COUNT([FIELD_ID]) > 1)
Hi William,
can you help me put my question into this context?
See my question:
https://community.esri.com/thread/215046-symbolizing-feature-class-using-related-table-values
Ingelogde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Maak gratis een account aan.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.