topic Re: Is there a way to do an SQL query for the lowest value? in Mapping Questions https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582975#M6385 <HTML><HEAD></HEAD><BODY><SPAN>Thanks - that worked great!</SPAN></BODY></HTML> Mon, 09 Jan 2012 18:55:11 GMT RebeccaNoll 2012-01-09T18:55:11Z Is there a way to do an SQL query for the lowest value? https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582973#M6383 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group.&nbsp; Is there a way to build a query for that?</SPAN><BR /><SPAN>Thanks!</SPAN><BR /><SPAN>Rebecca</SPAN></BODY></HTML> Mon, 09 Jan 2012 18:23:24 GMT https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582973#M6383 RebeccaNoll 2012-01-09T18:23:24Z Re: Is there a way to do an SQL query for the lowest value? https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582974#M6384 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I am trying to build a model that will first select a group of points based on an ID field and then select the lowest value in a distance field so I will get the shortest distance for each group.&nbsp; Is there a way to build a query for that?<BR />Thanks!<BR />Rebecca</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>No, not within a single table/feature class.&nbsp; There is a way to do it if there are two tables/feature classes.&nbsp; See the discussion on </SPAN><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000.htm">Subqueries here</A><SPAN>.&nbsp; I normally use the SummaryStatistics tool in the Analysis group to get a Min value and join it to the ID to select the lowest record or make other adjustments relative to the minimum value.</SPAN></BODY></HTML> Mon, 09 Jan 2012 18:53:28 GMT https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582974#M6384 RichardFairhurst 2012-01-09T18:53:28Z Re: Is there a way to do an SQL query for the lowest value? https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582975#M6385 <HTML><HEAD></HEAD><BODY><SPAN>Thanks - that worked great!</SPAN></BODY></HTML> Mon, 09 Jan 2012 18:55:11 GMT https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582975#M6385 RebeccaNoll 2012-01-09T18:55:11Z Re: Is there a way to do an SQL query for the lowest value? https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582976#M6386 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Thanks - that worked great!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Please mark the thread answered for the benefit of others looking for solutions to similar problems.&nbsp; I assume you used the SummaryStatistics approach given the speed of your respoinse.&nbsp; Thanks.</SPAN></BODY></HTML> Mon, 09 Jan 2012 19:01:26 GMT https://community.esri.com/t5/mapping-questions/is-there-a-way-to-do-an-sql-query-for-the-lowest/m-p/582976#M6386 RichardFairhurst 2012-01-09T19:01:26Z