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 / solasa

You can use aggregate (or summary) functions to summarize
the data in your tables. These functions can act on
multiple columns in a row or on a single column across rows.

Avg average of values •
NMiss number of missing values
Count number of non-missing values
• Prt probability of a greater absolute value of Student’s t
. CSS corrected sum of squares.
Freq (same as Count)
Nmiss,STDERR,MEan,Min,MAx etc


use this link:
http://www2.sas.com/proceedings/sugi30/257-30.pdf.


from
Solasa
solasa@in.com

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is treatment emergent events and treatment emregent adverse event

2446


how does sas handle missing values in procs? : Sas programming

1339


do you need to know if there are any missing values? : Sas programming

1118


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

1057


What do the PUT and INPUT functions do?

1379


which date functions advances a date time or date/time value by a given interval? : Sas programming

1003


How sas treats the dsd delimiters?

1258


What is PDV?

1202


what are the benefits of data integration? : Sas-di

1167


How to include or exclude specific variables in a data set?

1162


What are the data types that sas contain?

1244


What is the function of Stop statement in a SAS Program?

1193


how do you debug and test your sas programs? : Sas programming

1167


Can you execute a macro within a macro? Describe. : sas-macro

1148


how to remove duplicates using proc sql?

1194