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 |
What is the function of output statement in a SAS Program?
Do you need to rearrange the order of the data for the report?
How to display duplicate observations in data?
What are the different servers in sas? : sas-grid-administration
In sas, what are the areas that you are most interested in? : sas-grid-administration
What do you know about sas and what we do? : sas-grid-administration
what is portability of sas programmes?
How many data types are there in SAS?
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
what do you mean by data staging area? : Sas-di
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how do u validate sas program