What are the Aggregate functions in SQL ?

Answer Posted / singh.naveen409@gmail.com

There are some various kinds of aggregate functions, which
we have
like**************

AVG()=Average
COUNT()=Numbers of rows
FIRST()=First value
LAST()=Last Value
MAX()=Maximum value from rows
MIN()=Minimum Value from rows
SUM()=Total

Aggregate function which use to visualize the answer in
single value from tables value.

And Aggregate function use in sql with "HAVING" and where
condition.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the SAS data set?

685


what does the run statement do? : Sas programming

564


describe how to adjust the performance of data integrator? : Sas-di

574


What are pdv and it functions?

612


What are all the problems you faced while validating tables and reports?

3023






what is sas database server? : Sas-di

623


explain about sas business intelligence? : Sas-bi

604


How would you identify a macro variable?

661


Mention what are the data types does SAS contain?

703


what is sas and what are the functions? : Sas-administrator

550


Explain how merging helps to combine data sets.

620


what is sas olap server? : Sas-di

702


What system options would you use to help debug a macro? : sas-macro

650


Differentiate between proc means and proc summary.

612


Describe a time when you were really stuck on a problem and how you solved it?

2211