MySQL date functions that help you directly get required part of date. Commonly used MySQL date functions. These MySQL date functions are easy to remember.
reporting
How to calculate rank in MySQL
Many a time you need to calculate rank in MySQL. You can order by a number but can’t calculate rank in MySQL easily. Here’s a query you can use.
How to find nth rank in MySQL?
Many a time you need to fin nth rank in MySQL. To find nth rank in MySQL, we will calculate rank in MySQL. Then we filter the nth rank in MySQL.
Calculate decile in MySQL based on totals
You can calculate decile in MySQL to identify best customers. You can come up with more focused, relevant retention initiatives. Here’s a query to do it.
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.