Re: [Programmer-VB] Menampilin Top Ten

[Natanael]

select top 10 * from 'nama_table' order by 'NILAI'

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

 

 

Send instant messages to your online friends http://uk.messenger.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

•  Visit your group "Programmer-VB" on the web.
   
•  To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---