In PostgreSQL, the MIN() function computes the minimum of the non-null input values and returns the result.
This function can be used on any numeric, string, date/time, or enum type, as well as inet, interval, money, oid, pg_lsn, tid, and arrays of any of these types.
In MySQL, DATABASE() is a built-in function that returns the default (current) database name.
The result is returned as a string in the utf8 character set. If there is no default database, it returns NULL.
In SQLite, the table_list pragma returns information about the tables and views in the schema.
It was first introduced in SQLite version 3.37.0 (released on 2021-11-27).
Continue readingIn MySQL, the SUM() aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in an expression.
Continue readingIn MariaDB, the COUNT() aggregate function returns a count of the number of non-NULL values of an expression in the rows retrieved by a SELECT statement.
In MariaDB, the AVG() function returns the average value of the given expression.
The DISTINCT option can be used to return the average of the distinct values (i.e. remove duplicates before calculating the average).
NULL values are ignored.
In MariaDB, the SUM() aggregate function returns the sum of a given expression.
It can also be used to return the sum of all distinct (unique) values in an expression.
Continue readingSQL Server has a HAS_DBACCESS() function that returns information about whether the user has access to a specified database.
In MariaDB, MIN() is an aggregate function that returns the minimum value in a given expression.
In MariaDB, MAX() is an aggregate function that returns the maximum value in a given expression.