Di oracle silakan pake rownum select * from <nama_table> where rownum < 11 order by date;
On 6/7/06, Heriyanto KO <[EMAIL PROTECTED]> wrote: > > dear all, > > butuh bantuan nih... > saya ingin menampilkan 10 data terbaru dari suatu tabel.. > dulu sebelum migrasi ke oracle saya pake mysql > dengan format query > > select * > from nama_tabel > order by date > limit 1,10; > > tapi ketika saya coba di oracle kenapa gak bisa? > apa format limit di oracle berbeda? > thanks before > > > salam > > > hery > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Protect your PC from spy ware with award winning anti spy technology. It's free. http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
