Sunday , April 28 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

PostgreSQL Max Function

In today’s article, we will examine the general use and purpose of the PostgreSQL MAX() function.

The PostgreSQL MAX() function retrieves the largest value, indicated by expression in a set of grouped rows.

General Usage;

SELECT MAX(column_name) FROM table_name;

1	SELECT MAX(column_name) FROM table_name;

For example, if we want to find the object with the highest price among the products in our depo table, the following script will help us.

select max(satis_fiyati) from depo;

1	select max(satis_fiyati) from depo;

The picture below shows the highest price.