What are the Aggregate functions in SQL ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How long can a macro variable be? A token? : sas-macro
what is the diff. b/w proc means and proc summary?
What is proc sql pass through facility?
what is the difference between SET and MERGE?
Explain bmdp procedure?
define table lookup and how may ways it can be done...explian
how would you create multiple observations from a single observation? : Sas programming
what are some differences between proc summary and proc means? : Sas programming
where to use sas business intelligence? : Sas-bi
Differentiate between ceil and floor functions.
How is character variable converted into numeric variable and vice versa?
What is univariate n where it can be used n how...?