Professional Web Applications Themes

Selecting the 5 lowest from every group - MySQL

Hello All- I have a table containing items which each have an associated group (and a price). I have been trying to figure out how, in one statement, to select the 5 lowest priced items in every group. I could use the MIN function with a GROUP BY to find the lowest, but how could I find the N lowest? Thanks very much in advance... -- whit...

  1. #1

    Default Selecting the 5 lowest from every group

    Hello All-

    I have a table containing items which each have an associated group
    (and a price). I have been trying to figure out how, in one statement,
    to select the 5 lowest priced items in every group. I could use the MIN
    function with a GROUP BY to find the lowest, but how could I find the N
    lowest? Thanks very much in advance...

    -- whit

    pengypenguin@gmail.com Guest

  2. #2

    Default Re: Selecting the 5 lowest from every group


    com wrote: 

    What happens in the event of item 5 and item 6 having the same price?

    strawberry Guest

  3. Moderated Post

    Default Re: Selecting the 5 lowest from every group

    Removed by Administrator
    strawberry Guest
    Moderated Post

  4. #4

    Default Re: Selecting the 5 lowest from every group

    It's alright to break a tie randomly.

    strawberry wrote: 
    >
    > What happens in the event of item 5 and item 6 having the same price?[/ref]

    pengypenguin@gmail.com Guest

  5. Moderated Post

    Default Re: Selecting the 5 lowest from every group

    Removed by Administrator
    pengypenguin@gmail.com Guest
    Moderated Post

  6. Moderated Post

    Default Re: Selecting the 5 lowest from every group

    Removed by Administrator
    strawberry Guest
    Moderated Post

Similar Threads

  1. Lowest Noise Point and Shoot?
    By N.E.1. in forum Photography
    Replies: 6
    Last Post: September 22nd, 05:32 PM
  2. Get the lowest value out of different fields
    By Frank Keessen in forum PHP Development
    Replies: 4
    Last Post: September 3rd, 08:20 PM
  3. [PHP] Get the lowest value out of different fields
    By Chris W. Parker in forum PHP Development
    Replies: 1
    Last Post: September 3rd, 08:12 PM

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