adspace


How many aggregate functions are available there in sql?

Answer Posted / Madhu

"SQL provides several aggregate functions to perform calculations on a set of data. Some common ones include COUNT, SUM, AVG (average), MIN (minimum), and MAX (maximum). These functions can be used in SELECT statements to calculate the total number of rows, sum of values, average value, minimum value, or maximum value of a column."n

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is inner join faster than left join?

1287


how many tables will create when we create table, what are they? : Sql dba

1156


How do I remove duplicates in two columns?

1202


Can delete statement be rollbacked?

1065


Can we rollback truncate?

1083


Does group by remove duplicates?

1121


What is the best sql course?

1064


Is primary key always clustered index?

1101


What is the current version of sql?

1106


What is the current version of postgresql?

1188


what are all the common sql function? : Sql dba

1141


Can we use distinct and group by together?

1147


how to use regular expression in pattern match conditions? : Sql dba

1125


what is bcp? When does it used? : Sql dba

1065


what is schema? : Sql dba

1163