To return records from the database based on group by a certain columns, we use GROUP BY
keyword. This is generally done by those columns whose values are repeatative in nature into the database table.
To demonstrate this, we have used a view that was created as part of View examples discussed in the previous topic.
This view returns FirstName, LastName, Age from PersonalDetails table and NetSalary, PPFDeduction from Accounts table.
Now write following sql statement in the query window.
SELECT
LastName,
SUM(NetSalary) AS NetSalary,
SUM(PPFDeduction) AS PPFDeduction
FROM viewPersonalAccounts
GROUP BY LastName
This will sum NetSalary, PPFDeduction and give us the result grouped by LastName
Note
It is important to have the columns that are being used as Group by in the SELECT statement.
Views: 7061 | Post Order: 51