Percentile calculation helps helps you in ranking data and calculating median. Here’s how to calculate percentile in PostgreSQL.

# percentile

## How to Calculate Median in PostgreSQL

Median calculation helps find middle value and avoid data noise. Here’s how to calculate median in PostgreSQL.

## Calculate percentile in MySQL based on totals

It can be a pain to calculate percentile in MySQL. There are no functions for it yet. Here’s a ready made query to do it.

## Calculate percentile from frequency in MySQL

Calculate percentile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales

## Calculate percentile from recency in MySQL

Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders