Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 8116 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 |
Explain data_null_?
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
Explain why double trailing @@ is used in input statement?
What is the difference between nodupkey and nodup options?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
which domain is better in sas? clinical trails or banking
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
What are the uses of sas?
How do you add a prefix to some or all variables in a dataset using a SAS macro?
what are informats in sas? : Sas-administrator
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
Teradata 
