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

Appointment systems with sms and voice call feedback, Automated system for ...

Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

Sql, find the name of supplier who supply some red part

find the name of supplier who supply some red part

What is database utility, What is database utility? Database utility is...

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

Create a table to record a passengers information, Given the following rela...

Given the following relations TRAIN (NAME, START, DEST) TICKET (PNRNO., START, DEST, FARE) PASSENGER (NAME, ADDRESS, PNRNO.) Write SQL expressions for the following queries: No

Data Relation diagram, Can you assist me in Database management system? I n...

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...

In case of entity integrity the primary key may be declared, In case of ent...

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

FIELDS, 4. Describe three ways to handle missing field values

4. Describe three ways to handle missing field values

Fragmentation, Differentiate between horizontal & mixed horizontal fragment...

Differentiate between horizontal & mixed horizontal fragmentation?

Create a new service-based database, In this assignment, you will create a ...

In this assignment, you will create a program that works with multiple tables. In this assignment, you will work with the factory and sales tables. 1. Create a new project nam

Key to represent relationship between tables is called, Key to represent re...

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

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