In MySQL, we can format a number as a percentage by concatenating the number with the percent sign.
The CONCAT() function concatenates its arguments. We can pass the number as the first argument, and the percent sign as the second.
Category: DBMS
Database Management Systems
2 Ways to Add a Percent Sign to a Number in SQLite
Here are two ways to format a number as a percentage in SQLite.
Continue readingHow to Export Query Results to a .txt File when using SQLcl (Oracle)
When querying Oracle Database, you can use the SPOOL command to export your query results to a text file when using SQLcl.
How to Remove the Trailing Spaces after the Month Name in Oracle
If you’ve ever used the TO_CHAR() function to format a date that uses the month name, you might have noticed that sometimes the month is returned with right padding.
INSTR() Equivalent in SQL Server
Many RDBMSs have an INSTR() function that enables us to find a substring within a string. Some (such as MySQL and MariaDB) also have a LOCATE() function and a POSITION() function (also supported by PostgreSQL), that do a similar thing.
SQL Server doesn’t have an INSTR() function. Nor does it have a LOCATE() or POSITION() function. But it does have the CHARINDEX() function that does the same thing.
SQL Server also has the PATINDEX() function, which does a similar job to CHARINDEX().
3 Ways to Separate the Year, Month, and Day from a Date in MariaDB
MariaDB has several functions that enable you to extract various date and time parts from date/time values. You can use these to separate each date/time component into its own column if required.
Below are three ways to extract the year, month, and day from a date value in MariaDB.
Continue readingGROUP_CONCAT() Function in MySQL
MySQL 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.
LISTAGG() Function in Oracle
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.
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.