In Oracle, the LISTAGG() function enables us to combine data from multiple rows in to a single row.
We have the option of specifying a separator (such as a comma). We can also order the results produced by the LISTAGG() function, and more.
what is
MariaDB GROUP_CONCAT()
MariaDB has a GROUP_CONCAT() function that enables us to return columns from a query as a delimited list.
STRING_AGG() Function in PostgreSQL
In PostgreSQL, we can use the STRING_AGG() function to return columns from a query as a delimited list.
How POSITION() Works in PostgreSQL
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.
RPAD() Function in PostgreSQL
In PostgreSQL, RPAD() is a function that enables us to add padding to the right part of a string.
LPAD() Function in PostgreSQL
In PostgreSQL, LPAD()is a function that enables us to add padding to the left part of a string.
FORMAT() Examples in MySQL
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.
How CONCAT_WS() Works in PostgreSQL
In PostgreSQL, the CONCAT_WS() function concatenates two or more strings, placing a separator between each one. The separator is specified by the first argument.
How the CONCAT() Function Works in PostgreSQL
In PostgreSQL, the CONCAT() function concatenates the text representations of its arguments.