Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 8246 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 |
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is the difference between %put and symbolgen?
What is the order of evaluation of the following operators + - * / ** () ???
What are TEAEs
2 Answers Accenture, Quintiles,
Name statements that are execution only?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is the purpose of trailing @ and @@? How do you use them?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
What is the use of the %include statement?
Do you prefer Proc Report or Proc Tabulate? Why?
What is the purpose of _error_?
Teradata 
