Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Aggregate functions in SQL ?
- 2 Answers
- 8098 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 keep from overlaying the a SAS set with its sorted version?
What are the special input delimiters used in SAS?
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
How to convert .xls file into CSV format?
how does sas handle missing values in assignment statements? : Sas programming
name few built in sas transformation in DI studio ?
Are you involved in writing the inferential analysis plan? Tables specifications?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
what has been your most common programming mistake? : Sas programming
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
What is the difference between nodupkey and nodup options?
Teradata 
