4. What is Aggregate Functions?

What is Aggregate Functions?

Answer

Aggregate functions perform a calculation on a set of values and return a single value.
Aggregate functions ignore NULL values except COUNT function. HAVING clause is used,
along with GROUP BY, for filtering query using aggregate values.
Following functions are aggregate functions.
AVG, MIN, CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING,
VAR, MAX, VARP

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---