The median is the 'middle' value from a set of values. If the number of values is an even number, the median is the mean of the 'middle' values.

- Stackoverflow.com Wiki
1 articles, 0 books.

Finding the min, max, and avg price of an order in your purchases table is easy. But what about the median price? Medians are much more difficult for the database to compute, so there usually isn't a built-in function for this.