What is an Aggregate Function?

What is an Aggregate Function?

Aggregation Function is basically a type of function, which is use for the calculation on the set of values and It is also return the single value , Its also have a HAVING CLAUSE, Which is used along with GROUP BY.for filtering query using aggregate values, Its ignore NULL Values excpt COUNT Function, Its have a many functions which is there :
> AVG
> MIN
> CHECKSUM_AGG
> SUM
> COUNT
> STDEV
> COUNT_BIG
> STDEVP
> GROUPING
> VAR
> MAX
> VARP

By:UMANG
Date:2013-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher