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.


Example:   //Find the minimum, maximum and average salaries of employees of department 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
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

Question: AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin

Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT