Some RDBMSs have a GROUP_CONCAT() function that allows you to return a query column as a delimited list (for example, a comma separated list). MySQL and MariaDB are two that have such a function.
PostgreSQL and SQL Server have similar functions called STRING_AGG().
Oracle, on the other hand, has the LISTAGG() function that does pretty much the same thing (and perhaps more).
So you could say that LISTAGG() is Oracle’s GROUP_CONCAT() equivalent.
In MySQL, the JSON_VALUE() function extracts a value from a JSON document at the specified path.
The function was introduced in MySQL 8.0.21.
Continue readingMySQL has a GROUP_CONCAT() function that enables us to return columns from a query as a delimited list.
It returns a string result with the concatenated non-NULL values from a group.
MariaDB has a GROUP_CONCAT() function that enables us to return columns from a query as a delimited list.
In PostgreSQL, we can use the STRING_AGG() function to return columns from a query as a delimited list.
PostgreSQL has a POSITION() function that returns the first starting index of a specified substring within a string.
If the substring doesn’t exist in the string, then zero is returned.
Continue readingIn PostgreSQL, RPAD() is a function that enables us to add padding to the right part of a string.
In PostgreSQL, LPAD()is a function that enables us to add padding to the left part of a string.
In MySQL, the FORMAT() function returns a number formatted to a specified number of decimal places.
It includes group separators and a decimal separator where applicable.
Continue readingIn PostgreSQL, the CONCAT_WS() function concatenates two or more strings, placing a separator between each one. The separator is specified by the first argument.