How to find Max number form Oracle Column value?
It is string Value AG200810. How to find Max Value?. Substring AG2008 and find max value? Please Help it?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vishwas KadamannayaPosted Aug 22, 2013, 3:42 AM
select MAX(SUBSTR('AG200810',7, 2 )) from dual