How to set a filter for an estimated maximum price

Posted by David on Stack Overflow See other posts from Stack Overflow or by David
Published on 2010-04-07T10:33:42Z Indexed on 2010/04/07 10:43 UTC
Read the original article Hit count: 251

Filed under:
|

I cannot figure out how to set an estimated maximum price for a collection of records.

What I want to avoid is to simply use SQL MAX, because maybe there are records with exorbitant prices.

For example, in the "computers-hardware" category of OLX (http://www.olx.com/computers-hardware-cat-240) the filter for maximum price is estimately set to $1400, but sorting by price, the first items are above $10000

Maybe they calculated the average and then estimated some maximum price... what do you think?

And what about the stepping? How would you calculate it?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql