SQL Average, the part of Aggregate Function. SQL Average is used to compute average value of the records in a table of the database.
Understand with Example
The Tutorial illustrate an example from 'SQL Average'. To grasp and understand example we create a table 'stu' that has the required fieldnames and datatypes respectively.
Insert records into:
To add the value into the table 'Stu' we use insert into query.
The Query is used to return the id, name and average value of the marks records from table stu. The Group by keyword in SQL is used to sort the data uniquely on the basis of id records.