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 term- periodic recomputation, Explain the term- Periodic recomp... Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

What is trigger, What is Trigger? Trigger: A database trigger is proced... What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

Determine the un-normalized form, Un-Normalized Form (UNF) If a table h... Un-Normalized Form (UNF) If a table having non-atomic values at every row, it is said to be in UNF. An atomic value is something that cannot be further decomposed. A non-atomic

Complexity- drawbacks of data distribution, Complexity : A distributed DBMS... Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

What is authorization graph, What is authorization graph? Passing of au... What is authorization graph? Passing of authorization from single user to another can be shown by an authorization graph.

Develop database academic assignment, Develop Database academic assignment ... Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Which types of data supported by mysql, Which types of data supported by My... Which types of data supported by MySQL for Time and Date formats?  MySQL supports a number of time and date column formats: Some of them are 1) DATE 2) DATETIME 3) TIM

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.

What is message switching, What is Message switching Message switching ... What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

Data cube, Data slice explanation Data slice explanation