Launched first in the year 2010, Microsoft Azure is a popular cloud computing option for several businesses, not just because of the popularity that Microsoft enjoys, but also because of the platform’s unique and useful features. Even though Azure is the cloud computing option chosen by 85% of Fortune 500 companies, it has its’ limitations. […]
MySQL Date format is a very handy function. It formats a date as specified in the argument. Here’s a cheat sheet for MySQL date format function.
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.
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.
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 from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
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 decile 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. E.g, to rank customers based on recency of purchases or orders
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.