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 the one statement to set the criteria of data that can be coded in any step? : Sas programming

1128


Mention common programming errors committed in sas ?

1102


what are some good sas programming practices for processing very large data sets? : Sas programming

912


Name some categories in sas 9? : sas-grid-administration

961


What are the ways in which macro variables can be created in sas programming?

1085


how to debug and test the sas program? : Sas-administrator

1020


what is information maps?

2207


Give some examples where proc report’s defaults are different than proc print’s defaults?

1056


Explain translate function?

1185


how do you want missing values handled? : Sas programming

935


What are the advantages of using sas?

1132


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1215


do you prefer proc report or proc tabulate? Why? : Sas programming

968


What will calendar procedure do?

1056


Describe crosslist option in tables statement?

1210