Skip to content

Database.Guide

what is

MIN() Function in PostgreSQL

December 14, 2021 by Ian

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.

Read more

Categories PostgreSQL Tags aggregate functions, aggregation, functions, what is

DATABASE() – Get the Current Database Name in MySQL

December 12, 2021 by Ian

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.

Read more

Categories MySQL Tags functions, what is

PRAGMA table_list in SQLite

December 11, 2021 by Ian

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).

Read more

Categories SQLite Tags tables, what is

SUM() Function in MySQL

July 21, 2023December 10, 2021 by Ian

In 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.

Read more

Categories MySQL Tags aggregate functions, aggregation, functions, what is, window functions

COUNT() Function in MariaDB

July 21, 2023December 5, 2021 by Ian

In 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.

Read more

Categories MariaDB Tags aggregate functions, aggregation, functions, what is, window functions

AVG() Function in MariaDB

July 21, 2023December 4, 2021 by Ian

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.

Read more

Categories MariaDB Tags aggregate functions, aggregation, functions, what is, window functions

SUM() Function in MariaDB

July 21, 2023December 3, 2021 by Ian

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.

Read more

Categories MariaDB Tags aggregate functions, aggregation, functions, what is, window functions

HAS_DBACCESS() – Discover if a User Can Access a Database in SQL Server

December 2, 2021 by Ian

SQL Server has a HAS_DBACCESS() function that returns information about whether the user has access to a specified database.

Read more

Categories SQL Server Tags functions, security, what is

MIN() Function in MariaDB

July 21, 2023December 1, 2021 by Ian

In MariaDB, MIN() is an aggregate function that returns the minimum value in a given expression.

Read more

Categories MariaDB Tags aggregate functions, aggregation, functions, what is, window functions

MAX() Function in MariaDB

July 21, 2023December 1, 2021 by Ian

In MariaDB, MAX() is an aggregate function that returns the maximum value in a given expression.

Read more

Categories MariaDB Tags aggregate functions, aggregation, functions, what is, window functions
Older posts
Newer posts
← Previous Page1 … Page89 Page90 Page91 … Page166 Next →

About | Privacy Policy

© 2026 Database.Guide • All rights reserved