GREATEST Function in SQL

The GREATEST is a SQL numeric function which shows the greatest value from the specified inputs in Structured Query Language.

Syntax of GREATEST Function

In the GREATEST syntax, we have to pass those numbers from which we want to find greatest value.

In the Structured Query Language, we can also use the GREATEST function with the column of the table as shown in the following block:

In this syntax, we have to define the name and columns of that table on which we want to perform the GREATEST function.

Examples of GREATEST function

Example 1: This example returns the greatest from the specified numbers:

Output:

Example 2: This example returns the greatest from the specified numbers:

Output:

Example 3: This example returns the greatest value from the given inputs:

Output:

Example 4: This example returns the greatest representation of 255:

Output:

Example 5: This example returns the greatest value:

Output:

Example 6: This example uses the GREATEST function with the SQL table.In this example, we will create the new table through which we will perform the GREATEST function on the columns of the table:

The following shows the syntax to create the new table in SQL:

The following CREATE statement creates the Product_Details table for storing the price and quantity of products:

The following multiple INSERT queries insert the records of products with their selling and purchasing price into the Product_Details table:

The following SELECT statement displays the inserted records of the above Product_Details table:

Query 1: The following SELECT query uses the GREATEST function with the Product_Quantity and Product_ID column of the above Product_Details table:

This query shows the greatest value from the product id and quantity of each product.

Output:

Query 2: The following SELECT query uses the GREATEST function with Selling_Price and Purchasing_Price column of the above Product_Details table:

This query shows the greatest value from purchasing and selling price of each product.

Output:

Query 3: The following SELECT query uses the GREATEST function with the Purchasing_Price and Product_ID column of the above Product_Details table:

This query shows the greatest value from the product id and purchasing price of each product.

Output: