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

Log, what is the need of a log in dbms

what is the need of a log in dbms

What is a recursive relationship, Question: (a) Can a set of data requi...

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

What are the strategies of implementation of the statecharts, What are the ...

What are the different strategies of implementation of the Statecharts?  There are two strategies for implementation of state charts: i)   Basic Implementation Strategy

Create a database of a motor bike racing club, You have a friend that runs ...

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac

What is the need of a log in a dbms, What is the need of a log in a DBMS? B...

What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log.            Ans:  The system log, which is generally writt

Insulation between conceptual and physical structures, Insulation between c...

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

What are the basic objects of the data dictionary, What are the basic objec...

What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

How many types of data independence have, Types of data independence D...

Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi

Log, what is the need of a log in dbms

what is the need of a log in dbms

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