topic Is SELECT MAX possible with a Query.where? in ArcGIS API for Flex Questions https://community.esri.com/t5/arcgis-api-for-flex-questions/is-select-max-possible-with-a-query-where/m-p/373530#M8722 <HTML><HEAD></HEAD><BODY><SPAN>Am trying to retrieve an entry in a table (Oracle then SDE) that has a maximum value in one of it's fields but cannot get it right:</SPAN><BR /><BR /><SPAN>query.where = "OBJECTID=(SELECT MAX(OBJECTID) FROM TABLE_NAME)";</SPAN><BR /><BR /><SPAN>fails.</SPAN><BR /><BR /><SPAN>Is this functionality supported in the flex api (the equivilent call works from the service's query form) or have I just got the syntax wrong?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Martyn</SPAN></BODY></HTML> Fri, 09 Sep 2011 13:26:52 GMT MartynLe_Butt 2011-09-09T13:26:52Z Is SELECT MAX possible with a Query.where? https://community.esri.com/t5/arcgis-api-for-flex-questions/is-select-max-possible-with-a-query-where/m-p/373530#M8722 <HTML><HEAD></HEAD><BODY><SPAN>Am trying to retrieve an entry in a table (Oracle then SDE) that has a maximum value in one of it's fields but cannot get it right:</SPAN><BR /><BR /><SPAN>query.where = "OBJECTID=(SELECT MAX(OBJECTID) FROM TABLE_NAME)";</SPAN><BR /><BR /><SPAN>fails.</SPAN><BR /><BR /><SPAN>Is this functionality supported in the flex api (the equivilent call works from the service's query form) or have I just got the syntax wrong?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><BR /><SPAN>Martyn</SPAN></BODY></HTML> Fri, 09 Sep 2011 13:26:52 GMT https://community.esri.com/t5/arcgis-api-for-flex-questions/is-select-max-possible-with-a-query-where/m-p/373530#M8722 MartynLe_Butt 2011-09-09T13:26:52Z