What is aggregate function, Database Management System

Assignment Help:

What is aggregate function? Briefly describe it?

Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggregate functions:

a)      Average: avg

b)      Minimum:min

c)       Maximum: max

d)      Total:sum

e)      Count:count

Average: avg

Select avg (balance)

From account

Where branch-name='perryridge'

Count :count

Select branch-name,count(distinct customer-name)

From depositior,account

Where depositor.account-number=account.account-number

groupby branch-name

 


Related Discussions:- What is aggregate function

Development of an ER diagram and database implementation, i want answers th...

i want answers this assignment now if yiu can maket for me now ?

Describe participation constraints, Describe Participation Constraints? ...

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

What are temporary tables, What are temporary tables? Temporary tables...

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

Prepare heart failure registry database, Prepare Heart Failure Registry dat...

Prepare Heart Failure Registry database How are you today? Please I would like you to design a Heart Failure registry where doctors will log in to enter information about their

Relationship, What is multiple relationship ?

What is multiple relationship ?

What are the two statements regarding transaction, What are the two stateme...

What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A)     Begin transaction B)      End transaction

Data control, Identify the need and use of data control through problem sol...

Identify the need and use of data control through problem solving, illustration

Process to find the non-concurrent objects, Process to find the non-concurr...

Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O

What is meant by mean time to failure, What is meant by mean time to failur...

What is meant by mean time to failure? The mean time to failure is the amount of time that the system could run continuously without failure.

Define the term- control as state within program, Control as State within P...

Control as State within Program 1.  The term control exactly means to check effect of input within a program. For illustration, in Figure, after the ATM card is inserted (a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd