Page 90 - SQL

ContinentCode

EU

AS

NA

NA

AF

AF

AllCount: 7 SingleCount: 5

Max

Find the maximum value of column:

select max(age) from employee;

Above example will return largest value for column age of employee table.

Syntax:

SELECT MAX(column_name) FROM table_name;

Min

Find the smallest value of column:

select min(age) from employee;

Above example will return smallest value for column age of employee table.

Syntax:

SELECT MIN(column_name) FROM table_name;

Read Functions (Aggregate) online: https://riptutorial.com/sql/topic/1002/functions--aggregate-

https://riptutorial.com/ 72