terimakasih atas tanggapannya nich..
tapi saya rasa querynya tidak flexibel.
--- Denny Kusumah <[EMAIL PROTECTED]> wrote:
> Saudara ashfi anda bisa mencoba query berikut untuk
> mendapatkan nilai maximal dari suatu data bertipe
> varchar
>
>
> -------------------------------------
> SELECT MAX(no_drum) max_no_drum
> FROM (
> SELECT TO_NUMBER('1') no_drum FROM dual
> UNION
> SELECT TO_NUMBER('2') no_drum FROM dual
> UNION
> SELECT TO_NUMBER( '2') no_drum FROM dual
> UNION
> SELECT TO_NUMBER('25') no_drum FROM dual
> UNION
> SELECT TO_NUMBER('23') no_drum FROM dual
> )
> --------------------------------------
>
>
>
>
>
>
>
> --- abe ashfi <[EMAIL PROTECTED]> wrote:
>
> > Dear all,
> >
> > hallo semua..
> >
> > ak punya problem nich.
> > ak mau nentuin nilai max yg ada di 1 field bertipe
> > varchar.
> >
> > nah datanya
> >
> > no_drum
> > -------
> > 1.2.25.23
> >
> > nah dari data diatas, saya mau ambil nilai max.
> > klo diliat dari data bisa didapat nilai max itu
> 25.
> >
> > gimana y dapetin nilai max itu.
> > mungkin rekan2 oracle lovers udah pernah atau ada
> yg
> > bisa pecahin problem saya.
> >
> > Trimakasih.
> >
> > Salam hangat,
> >
> > -ashfi-
> >
> >
> >
> >
> >
> >
>
____________________________________________________________________________________
> > Never miss a thing. Make Yahoo your home page.
> > http://www.yahoo.com/r/hs
> >
>
>
>
>
>
____________________________________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
