Returns sum of numeric values in a given column.
We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet.
Select SUM(MarksObtained) From Marksheet
The sum function doesn't consider rows with NULL value in the field used as param...
Returns average of numeric values in a given column.
We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet.
Select AVG(MarksObtained) From Marksheet
The average function doesn't consider rows with NULL value in the field used ...
Returns the largest value in a given column.
We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet.
Select MAX(MarksObtained) From Marksheet
Returns the smallest value in a given column.
We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet.
Select MIN(MarksObtained) From Marksheet
Returns the total number of values in a given column.
We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet.
Select COUNT(MarksObtained) From Marksheet
The count function doesn't consider rows with NULL value in the field used...
Most of the time we like to get the total number of occurrence of a column value in a table for example:
TABLE NAME : REPORTS
ReportNameReportPriceTest10.00 $Test10.00 $Test10.00 $Test 211.00 $Test10.00 $Test 314.00 $Test 314.00 $Test 4100.00 $
SELECT
ReportName AS REPORT ...
