[ACCEPTED]-Select average from MySQL table with LIMIT-average

Accepted answer
Score: 61

I think this is what you're after:

SELECT AVG(items.price)
  FROM (SELECT t.price
          FROM TABLE t
         WHERE t.price > '0' 
           AND t.item_id = '$id'
      ORDER BY t.price
         LIMIT 5) items

It will 2 return the average of the 5 lowest prices 1 - a single answer.

Score: 0

Simple solution below.


SELECT  AVG(Column_name) 
FROM  (SELECT Column_name 
FROM  Table
WHERE  ColumnID < number[Limit you want] )


More Related questions