[ACCEPTED]-Select average from MySQL table with LIMIT-average
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.
Simple solution below.
SELECT AVG(Column_name) FROM (SELECT Column_name FROM Table WHERE ColumnID < number[Limit you want] )
More Related questions