What are the Aggregate functions in SQL ?

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


Please Help Members By Posting Answers For Below Questions

AE datasets names? how many types?

2254


Describe crosslist option in tables statement?

935


how does sas handle missing values in assignment statements? : Sas programming

783


Explain substr function?

786


What system options would you use to help debug a macro? : sas-macro

857


What are types of transport files?

7360


What function CATX syntax does?

879


What are the special input delimiters used in SAS?

862


Explain the purpose of retain statement.

797


What can be the size of largest dataset in SAS?

937


what is ae onset date n what is RDS

2140


Name few SAS functions?

873


what is the difference between unique key and primary key? : Sas-di

826


Have you ever used the SAS Debugger?

1460


What do the mod and int function do? : Sas programming

819