Loading ...
Sorry, an error occurred while loading the content.

RE: [vb-indo] Menampilin Top Ten

Expand Messages
  • Ricky
    select top 10 * from order by desc ... From: skdmdn [mailto:skdmdn@diamond.co.id] Sent: Tuesday, January 31, 2006 8:44 PM To:
    Message 1 of 2 , Jan 31, 2006
    • 0 Attachment
      select top 10 * from <tabel> order by <field> desc

      -----Original Message-----
      From: skdmdn [mailto:skdmdn@...]
      Sent: Tuesday, January 31, 2006 8:44 PM
      To: programmer-vb@yahoogroups.com; vb-indo@yahoogroups.com
      Subject: [vb-indo] Menampilin Top Ten


      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



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



      Mailing list VB berbahasa Indonesia untuk para pengguna serta fans VB.

      Yahoo! Groups Links
    Your message has been successfully submitted and would be delivered to recipients shortly.