Allo Mas Fansul,

Mungkin bisa dengan cara seperti ini

Select *
>From (
   select jual.*, rownum as rown
   from jual
   where rownum <= 5
)
Where rown = 5;

Cheers,
Wadi Achmed

2010/4/5 <[email protected]>

> Hello indo-oracle,
>
>  mau tanya, bagaimana cara mengambil nomor row ya.
>  misalnya table jual ada 10 row, saya mau filter row nomor 5
>  saya udah coba seperti ini kok nggak mau ya
>
>  select * from jual where rownum = 5
>
>
>
>
>
>
> --
> Best regards,
> fansul
> mailto:[email protected]
>
> __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap
> spam
> http://id.mail.yahoo.com
>
>
>
> ------------------------------------
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [email protected]
> Website: http://indooracle.wordpress.com
> http://www.facebook.com/group.php?gid=51973053515
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.blogspot.comYahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]

Kirim email ke