SQL Aggregate Functions First
SQL Aggregate Function First, that performs calculation of data. The SQL aggregate function retrieve a single value, by calculate from values in a column.
Understand with Example
The Tutorial illustrate an example from SQL Aggregate Functions First. The Example create a table 'Stu_Table'. The create table keyword create a table 'Stu_Table' with field attribute like 'Stu_Id','Stu_Name' and 'Stu_Class' .Each fields in the table have different data type respectively.
create the Table Stu_Table
SQL statement to create table:
Insert data into Stu_Table
Insert into keyword add the records or rows to the table 'Stu_Table'.
SQL statement to insert data into table:
Records in the table:
The given Query return you the records and retrieve a single value, by calculate from values in a column 'stu_name' enlisted in the select statement from 'Stu_Table'. The group by keyword group all the records which is grouped by attribute 'stu_id' from a table 'Stu_Table'.