Computer Science, asked by parnicad2003, 1 day ago

briefly describe the aggregate function in SQL with some example

Answers

Answered by anshumita33

0

Explanation:

AVG : Calculates the average of a set of values .
COUNT : Gets the rows in a specified table overview.
MIN : Gets the maximum value in a set of values .
SUM : Calculates the sum of values .

Previous Question

Next Question

Similar questions

Math, 1 day ago

what percent of all numbers between 1 and 200 are multiplies of 5? express your answer in hundredths...

Math, 1 day ago

this is a maths question (x+3)(x=5)...

Biology, 1 day ago

Why facts are solid and oils are liquid at room temperature?

Chemistry, 1 day ago

What are the examples of simple distillation?

Math, 1 day ago

28. Saeed Anwar's average in each match was increased by 3 runs when he scored 80 in his 15th inning. What was his average after the 15th inning? A. 35 B. 38 C. 41 D.48 ame...

Social Sciences, 8 months ago

Who looks after sanitary conditions of the country? * 1 point Health Minister Home Minister Finance Minister All of these...

Biology, 8 months ago

D. Fill in the blanks in the following paragraph using just two words-arteries and veins. [NCERT Exemplar Problems] (a)............ carry oxygen-rich blood from the heart to all parts of the body and (b).................. carry carbon dioxide-rich blood from all parts of the body back to the heart. (c).............. have thin walls and (d)........... have thick elastic walls. Blood flows at...

English, 8 months ago

write an essay on save the ocean. must include introduction body and conclusion. u should also tell why should we save oceans and what or who is affected by the ocean.plzzz it's emergency hurry it...