Professional Web Applications Themes

select a single row based on a field value? - MySQL

HI how can I select the row with the 100th highest value in one of the fields using SQL? I'm building a large scoreboard and I want to find it the current user's score is higher than the person's in position 100. Thanks Ciarán...

Sponsored Links
  1. #1

    Default select a single row based on a field value?

    HI how can I select the row with the 100th highest value in one of the
    fields using SQL? I'm building a large scoreboard and I want to find
    it the current user's score is higher than the person's in position
    100.

    Thanks
    Ciarán

    Sponsored Links
    Ciaran Guest

  2. #2

    Default Re: select a single row based on a field value?

    On 13 Mar 2007 09:16:55 -0700, Ciaran wrote: 

    SELECT user_score FROM user_score_table
    ORDER BY user_score DESC LIMIT 99,1;

    LIMIT starts counting at 0.

    --
    99. Any data file of crucial importance will be padded to 1.45Mb in size.
    --Peter Anspach's list of things to do as an Evil Overlord
    Peter Guest

  3. #3

    Default Re: select a single row based on a field value?

    hey thanks a lot! I really should have realised it was that easy! Live
    and Learn!
    Thanks again
    Ciarán

    Ciaran Guest

Similar Threads

  1. Replies: 3
    Last Post: May 18th, 10:03 AM
  2. Select a list of items into an aliased field when doinga select
    By ehaemmerle in forum Coldfusion Database Access
    Replies: 3
    Last Post: March 18th, 10:49 PM
  3. Replies: 6
    Last Post: January 17th, 07:46 PM
  4. SQL SELECT Based on *PART* a text Field?
    By wetchman in forum ASP
    Replies: 3
    Last Post: September 15th, 07:54 PM
  5. Replies: 0
    Last Post: June 29th, 12:15 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139