Group function and aggregate function

Group function and aggregate function

SQL group function or aggregate function retuns single value from the group.

These are built in function in sql and oracle

Aggegate function.

Min – This function is used to get the mimimum value from the specified column

Max- This function is used to get the maximum value from the specified column

Sum- This function is used to get the sum if numeric column

Count- This function is used to get the actual number of values (count)  from the  column

Avg- this function used to get the average value from the column.

Group function

Distinct

The distinct () function is used to get the disctinct record from the column.

select distinct(TitleOfCourtesy) from Employees