Kalau anda pake Sql Server databae kita bisa pake perintah TOP n seperti contoh dibawah:
select TOP 10 * from table abc order by nilai DESC santosa --- skdmdn <[EMAIL PROTECTED]> wrote: > Teman2, > > Misal saya punya tabel data: > > NAMA NILAI > AAA 7 > BBB 10 > CCC 8 > DDD 6 > EEE 5 > FFF 7 > GGG 9 > HHH 6 > IIII 8 > JJJ 4 > KKK 3 > LLL 7,5 > MMM 8,1 > NNN 9,9 > > Bagaimana perintah sqlnya untuk menampilkan nilai2 > 10 besar tertinggi? > Thank's B4 > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> 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/
