kalau anda ingin flexibel, format query berikut
mungkin bisa membantu :
SELECT max(to_number(nama_field)) FROM nama_tabel
--- abe ashfi <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
