MySQL CUME_DIST Function Summary: in this tutorial, you will learn how to use the MySQL CUME_DIST() function to calculate cumulative distribution value. Overview of MySQL CUME_DIST() Function The CUME_DIST() is a window function that returns the cumulative distribution of a value within a set of values. It represents the number of rows with values less than…
Read more
MySQL Window Functions Summary: in this tutorial, you will learn about MySQL window functions and their useful applications in solving analytical query challenges. MySQL has supported window functions since version 8.0. The window functions allow you to solve query problems in new, easier ways and with better performance. Suppose that we have the sales the…
Read more
MySQL UPPER Function Summary: in this tutorial, you will learn how to use the MySQL UPPER() function to convert a string to uppercase. MySQL UPPER() function overview The UPPER() function returns the uppercase of a specified string argument. The following shows the syntax of the UPPER() function: UPPER(str) Code language: SQL (Structured Query Language) (sql)…
Read more
MySQL FORMAT Function Summary: this tutorial shows you how to use the MySQL FORMAT function to format decimal numbers in various locales. Introduction to the MySQL FORMAT function Sometimes, you use an expression or an aggregate function such as AVG to calculate values in the databases such as inventory turnover, the average net price of…
Read more
MySQL FIND_IN_SET Function Summary: in this tutorial, you will learn how to use the MySQL FIND_IN_SET() function to return the position of a string in a comma-separated list of strings. Introduction to MySQL FIND_IN_SET() function MySQL provides a built-in string function called FIND_IN_SET() that allows you to find the position of a string within a comma-separated…
Read more
MySQL TRIM Function Summary: in this tutorial, we will show you how to use the MySQL TRIM() function to remove the unwanted leading and trailing characters from a string. Introduction to the MySQL TRIM() function The data from the user’s input is typically not what we expected. Sometimes, it is not well-formed, for example, wrong…
Read more
MySQL SUBSTRING_INDEX Function Summary: in this tutorial, you will learn how to use the SUBSTRING_INDEX() function to get a substring from a string before a specified number of occurrences of the delimiter. MySQL SUBSTRING_INDEX() function overview The SUBSTRING_INDEX() function returns a substring from a string before a specified number of occurrences of the delimiter. Here…
Read more
MySQL SUBSTRING Function Summary: in this tutorial, we will introduce you to the MySQL SUBSTRING function that extracts a substring from a string. The SUBSTRING function returns a substring with a given length from a string starting at a specific position. MySQL provides various forms of the substring function. We will examine each form of…
Read more
MySQL RTRIM Function Summary: in this tutorial, you will learn how to use the RTRIM() function to remove all trailing spaces of a string. MySQL RTRIM() overview The RTRIM() function takes a string argument and returns a new string with all the trailing space characters removed. Here is the syntax of the RTRIM() function: RTRIM(str)…
Read more
MySQL RIGHT Function Summary: in this tutorial, you will learn how to use the MySQL RIGHT() function to get a specified number of rightmost characters from a string. MySQL RIGHT() function overview The MySQL RIGHT() function extracts a specified number of rightmost characters from a string. Here is the syntax of the RIGHT() function: RIGHT(str,length)…
Read more