AVG – calculates the average of a set of values.
COUNT – counts rows in a specified table or view.
MIN – gets the minimum value in a set of values.
MAX – gets the maximum value in a set of values.
SUM – calculates the sum of values.
COUNT – counts rows in a specified table or view.
MIN – gets the minimum value in a set of values.
MAX – gets the maximum value in a set of values.
SUM – calculates the sum of values.
There are 5 types of SQL aggregation function-
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...
In reply to First post
Re: Discussion about SQL queries in Aggregation Function
by Md Nurnobi Hosen -
There are 5 types of SQL aggregation function-
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...
There are 5 types of SQL aggregation function-
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...
1)AVG: It calculates the average of a set of values...
2)COUNT: It counts rows in a specified table or view...
3)MIN: This function gets the minimum value in a set of values...
4)MAX: This function gets the maximum value in a set of values...
5)SUM: It calculates the summation of values...