Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 7965 Views
- AON, I also Faced
- E-Mail Answers
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 |
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
Difference between informat and format?
How to write duplicate records into a separate dataset using sort?
What is a post baseline?
How to create an external dataset with sas code?
In sas, what are the areas that you are most interested in? : sas-grid-administration
How to sort in descending order?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Explain the difference between using drop = data set option in set and data statement?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
what is option year cuttoff in sas
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Teradata 
