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
