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

Ask an Expert

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

Write your message here..

Related Questions

Explain the benefit of oom, Explain the benefit of OOM. Main benefits o... Explain the benefit of OOM. Main benefits of object oriented modeling are development of system become fast, quality of the system get improve. It gives freedom of use of alrea

Entity-relationship diagram, 1. Item based services will be charged fixed p... 1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa

What is foreign key, What is foreign key? Foreign Key - Let there are... What is foreign key? Foreign Key - Let there are two relations in tables R and S. Any candidate key of the relation R that is referred in the relation S is known as the forei

Define cascading rollback, Define Cascading rollback The phenomenon whe... Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

ENTITY DIAGRAMS IN FIRST NORMAL FORM, CAN SOMEONE HELP ME WITH ENTITY DIAGR... CAN SOMEONE HELP ME WITH ENTITY DIAGRAMS IN FIRST NORMAL FORM?

What is relationship, What is relationship? Give examples A relationshi... What is relationship? Give examples A relationship is an association between several entities. Example: A depositor relationship associates a customer with every account tha

Explain the exec statement in sql, Explain the Exec statement in SQL An... Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

Explain what is relation, Explain What is Relation? A database relatio... Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Derived horizontal fragmentation, Derived horizontal fragmentation: Some ap... Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

Eer diagram, Design an EER schema for the following application and transla... Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured