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
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? 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

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 : 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? Passing of authorization from single user to another can be shown by an authorization graph.

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 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

I need some help with my normalization database homework.

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 slice explanation