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

Do you know the features of sas?

1044


Explain the special input delimiters used in sas programming.

1008


How we can call macros with in data step? : sas-macro

1125


how does sas handle missing values in sort order? : Sas programming

920


What is the use of %include statement?

1063


Name any two sas spawners? : sas-grid-administration

1039


What is maximum number of rows and cols can be handled in SAS?

1588


how will you locate the sas platform applications? : Sas-bi

1033


How to limit decimal places for the variable using proc means?

1071


how the sas basic syntax style described? : Sas-administrator

1019


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

3472


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1152


What’s the difference between var b1 – b3 and var b1 — b3?

1366


How to specify variables to be processed by the freq procedure?

1076


For what purpose would you use the RETAIN statement?

1524