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

Create student db and perform delete operation, Create Student DB and perfo... Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

Implementing a data warehouse, (a) Data warehouse can be defined as "a sub... (a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea

Set difference, Set Difference If R1 and R2 are two union compatible re... Set Difference If R1 and R2 are two union compatible relations or relations then result of R3 =R1- R2 is the relation that have only those tuples that are in R1 but not in R2.

Why as clause is used in sql, Why 'AS' clause is used in SQL ? 'As' cla... Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

Functional dependency, Functional Dependency Consider a relation R that... Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

State about the tables- DBMS, State about the Tables- DBMS Data is sto... State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Creating views with replace option, Creating views with Replace option : Th... Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

Explain the exec statement in sql, Explain the EXEC statement in SQL  A... Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

single products ordered, For Colorado customers calculate the number of si... For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

Write short notes on tuple relational calculus, Write short notes on tuple ... Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul