Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 substr function?

1174


What is the sas data set? : sas-grid-administration

971


what is sas metadata repository? : Sas-bi

1108


What is a put statement?

1191


What is SAS?

1044


where to use sas business intelligence? : Sas-bi

1073


Explain proc sort?

1076


how can you import .csv file in to sas? : Sas programming

1082


why is a stop statement needed for the point=option on a set statement? : Sas programming

1075


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2011


How would you determine the number of missing or nonmissing values in computations?

1058


What are the parameters of scan function?

1162


for what purpose would you use the retain statement? : Sas programming

1076


How do you add a number to a macro variable? : sas-macro

998


How you can read the variables that you need?

1118