Results 1 to 3 of 3

Thread: OleDB Commands

Threaded View

  1. Apr 8th, 2003, 10:15 PM #1
    LuvKnight
    LuvKnight is offline

    Thread Starter
    Member
    Join Date
    Mar 2003
    Posts
    32

    OleDB Commands

    "Select * from Scores order by Score DESC"

    I've this line of command that retrive everything from the Scores database sorting by the Score in decending order. Is there anyway that I could only retrive the first 10 entry when it's in decending, thus retriving only the top 10?


    [EDIT]
    Eh! I've another idea, how do I limit the database to 10 records ONLY? So if I've a new score that is higher than the lowest score in the database. It'll kick out the lower score and put itself in it's place?

    I've a idea of using Array taking all the 10 results and comparing which the lowest, (I dunno how to compare 10 results) and putting it back in.

    Hope someone understands!
    [/EDIT]
    Last edited by LuvKnight; Apr 8th, 2003 at 10:30 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width