https://community.esri.com/t5/arcgis-pro-questions/sql-code-to-query-most-recent-data-for-a-point/m-p/1182175#M56127 <P>Hello Esri Family,</P><P>I'm trying to write a definition query for a layer in my data so that if one point has multiple years of data, only the most recent year is displayed. I wrote the SQL query attached in order to tediously make a series of 'Or' statements in the definition query, but all those will need to be updated the next time data is collected.<BR /><BR />I want "year &gt;= Most_Recent_Year" but am not sure how to make that happen in the SQL query box.</P><P>If you have a reference or advice I'd appreciate it! Please &amp; thank you.</P> Sun, 12 Jun 2022 20:04:42 GMT LindsayDupont 2022-06-12T20:04:42Z https://community.esri.com/t5/arcgis-pro-questions/sql-code-to-query-most-recent-data-for-a-point/m-p/1182175#M56127 <P>Hello Esri Family,</P><P>I'm trying to write a definition query for a layer in my data so that if one point has multiple years of data, only the most recent year is displayed. I wrote the SQL query attached in order to tediously make a series of 'Or' statements in the definition query, but all those will need to be updated the next time data is collected.<BR /><BR />I want "year &gt;= Most_Recent_Year" but am not sure how to make that happen in the SQL query box.</P><P>If you have a reference or advice I'd appreciate it! Please &amp; thank you.</P> Sun, 12 Jun 2022 20:04:42 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-code-to-query-most-recent-data-for-a-point/m-p/1182175#M56127 LindsayDupont 2022-06-12T20:04:42Z