topic how to find highest value in sql in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-find-highest-value-in-sql/m-p/489241#M27806 <HTML><HEAD></HEAD><BODY><P>I have lots of data and id like <SPAN style="font-size: 12pt;">RAL12345786</SPAN>. so i want to find&nbsp; whose the highest value in database in same format string and numeric.</P><P>i am using <SPAN style="font-size: 12pt;">SQL oracle</SPAN></P><P>please tell me how to find it.</P><P>Kapil</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 127px;"><TBODY></TBODY></TABLE></BODY></HTML> Wed, 27 Aug 2014 10:41:05 GMT kapildev 2014-08-27T10:41:05Z how to find highest value in sql https://community.esri.com/t5/data-management-questions/how-to-find-highest-value-in-sql/m-p/489241#M27806 <HTML><HEAD></HEAD><BODY><P>I have lots of data and id like <SPAN style="font-size: 12pt;">RAL12345786</SPAN>. so i want to find&nbsp; whose the highest value in database in same format string and numeric.</P><P>i am using <SPAN style="font-size: 12pt;">SQL oracle</SPAN></P><P>please tell me how to find it.</P><P>Kapil</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 127px;"><TBODY></TBODY></TABLE></BODY></HTML> Wed, 27 Aug 2014 10:41:05 GMT https://community.esri.com/t5/data-management-questions/how-to-find-highest-value-in-sql/m-p/489241#M27806 kapildev 2014-08-27T10:41:05Z Re: how to find highest value in sql https://community.esri.com/t5/data-management-questions/how-to-find-highest-value-in-sql/m-p/489242#M27807 <HTML><HEAD></HEAD><BODY><P>Are you saying that the field is a text field with both alpha and numeric values inside?</P><P></P><P>If that is the case, then you would need to either select for maximum based on another field, or extract numeric data from this field to use for selecting a highest value. A text field is just text, there is no inherent hierarchy. </P><P></P><P>You could pull the numeric portion of that field out using LEFT () or RIGHT() and use that to find the MAXIMUM () value, assuming that the numeric portion of the field indicates a highest value.</P></BODY></HTML> Wed, 27 Aug 2014 14:46:04 GMT https://community.esri.com/t5/data-management-questions/how-to-find-highest-value-in-sql/m-p/489242#M27807 AngelynSnyder 2014-08-27T14:46:04Z