aggregate functions-data manipulation language, Database Management System

Aggregate functions

  • Some of these functions are min, count, max, and avg.
  • These functions help in getting consolidated information from a set of tuples.

Example: Find the total number of employees.

SELECT COUNT (*) FROM EMP;

Example:   //Find the minimum, maximum and average salaries of employees of department D1//.

SELECT MIN(SAL), MAX (SAL), AVG(SAL) FROM EMP

WHERE DEPTNO = 'D1' ;

 

 

Posted Date: 3/11/2013 1:07:53 AM | Location : United States







Related Discussions:- aggregate functions-data manipulation language, Assignment Help, Ask Question on aggregate functions-data manipulation language, Get Answer, Expert's Help, aggregate functions-data manipulation language Discussions

Write discussion on aggregate functions-data manipulation language
Your posts are moderated
Related Questions
Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s

Describe the different RAID levels.  Discuss the choices of the different RAID levels for different applications.          Ans:   There are several combinations of these approa

What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

You are required to implement integrity constraints within the database to enforce the following requirements:  For Projects: Start date must be supplied. Start date cannot be i

Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials. This database will help the Parents Assocc



What are the several forms of identity? a) Value b) Name c) Built-in