Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the DENSE_RANK() function works in Mariadb?

The DENSE_RANK() function is a window function that assigns a rank to each row within a partition of a result set.

Install SQLite on Ubuntu 18.04 for an existing system. Standard security maintenance ended in 2023; Ubuntu Pro ESM may cover it through 2028.

The CHARACTER_LENGTH() function is a string function that returns the number of characters in a given string.

The DEGREES() function is a mathematical function that converts an angle value from radians to degrees.

Install the SQLite command-line shell on Rocky Linux 9 with DNF and verify that the sqlite3 client is available.

The CHAR() function is a string function that returns a string value composed of one or more characters based on their numeric codes.

Install the sqlite3 command-line client on Rocky Linux 8 with DNF, verify its version, and create a persistent database file.

Learn how MariaDB DECODE() reverses ENCODE() in the default SQL mode, and why this legacy pair is not secure encryption.

The CHAR_LENGTH() function is a string function that returns the number of characters in a given string.

Install the sqlite3 command-line client on Red Hat Enterprise Linux 9 with DNF, verify its version, and create a persistent database file.