median

Medians in SQL

• sql median

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.