Answer Posted / 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 |
Post New Answer View All Answers
How substr function works in sas?
What is Linear Regression?
Have you used macros? For what purpose you have used? : sas-macro
Describe a time when you were really stuck on a problem and how you solved it?
what is sas metadata repository? : Sas-bi
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is proc Index? and what is proc document?
What is the sas data set? : sas-grid-administration
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Explain why double trailing @@ is used in input statement?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what is sas metadata server? : Sas-di
Give e an example of..
