Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 8130 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 |
How would you combine 3 or more tables with different structures?
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?
How to limit decimal places for variable using proc means?
what is OLAP?
How can you create a macro variable with in data step? : sas-macro
How to limit decimal places for the variable using proc means?
Difference between SAS STATA & SPSS?
Mention some common errors that are usually committed in sas programming.
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
what is syntax of proc merge ?
Why do we use QUIT commmand for proc datasets and proc sql ???
how can you import .csv file in to sas? : Sas programming
Teradata 
