Home >> SQL >> Max in SQL

Max in SQL

The MAX returns the highest value of the selected column.

Syntax

SELECT MAX(columnname) FROM tablename WHERE condition;

Example

SELECT MAX(price) AS highestprice FROM products;

Interview Questions

Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.