topic SELECT only one record of THE OLDEST OR NEWEST DATA FOR SUBTYPES: 1,2,3,4, 5. in Spatial Data Science Questions https://community.esri.com/t5/spatial-data-science-questions/select-only-one-record-of-the-oldest-or-newest/m-p/1282948#M1867 <P>I have few subtypes of services that were installed at different times with a lot of duplicates. How do I select only one data the oldest (or newest) for each subtype:&nbsp;</P><P>I have used:&nbsp; INSERVICEDATE &lt; date '2022-12-02 00:00:00' AND SUBTYPECD =1 but I get too many records.&nbsp;</P> Wed, 26 Apr 2023 17:37:52 GMT TatianaVlad 2023-04-26T17:37:52Z SELECT only one record of THE OLDEST OR NEWEST DATA FOR SUBTYPES: 1,2,3,4, 5. https://community.esri.com/t5/spatial-data-science-questions/select-only-one-record-of-the-oldest-or-newest/m-p/1282948#M1867 <P>I have few subtypes of services that were installed at different times with a lot of duplicates. How do I select only one data the oldest (or newest) for each subtype:&nbsp;</P><P>I have used:&nbsp; INSERVICEDATE &lt; date '2022-12-02 00:00:00' AND SUBTYPECD =1 but I get too many records.&nbsp;</P> Wed, 26 Apr 2023 17:37:52 GMT https://community.esri.com/t5/spatial-data-science-questions/select-only-one-record-of-the-oldest-or-newest/m-p/1282948#M1867 TatianaVlad 2023-04-26T17:37:52Z