how to find highest value in sql

3576
1
08-27-2014 03:41 AM
Highlighted
New Contributor III

I have lots of data and id like RAL12345786. so i want to find  whose the highest value in database in same format string and numeric.

i am using SQL oracle

please tell me how to find it.

Kapil

Reply
0 Kudos
1 Reply
Highlighted
New Contributor III

Are you saying that the field is a text field with both alpha and numeric values inside?

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.

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.