aggregate functions-data manipulation language, Database Management System

Assignment Help:

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

Related Discussions:- aggregate functions-data manipulation language

Explain query tree represent relational algebra expression, How does a quer...

How does a query tree represent a relational algebra expression? Ans: This includes transforming an initial expression (tree) into an equivalent expression (tree) that is

Database for Managers, I have to create a database about anything of my cho...

I have to create a database about anything of my choice. It has to contain 4 queries, and 4 forms. It can be anything as simple as a shoe inventory with numbers - is this a service

Discuss the method for a hash file to expand shrink dynamic, Discuss the me...

Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

Customer service, as a customer service employee, explain five measures you...

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

Define serializable schedule, Define Serializable schedule Serializable...

Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

Illustration of implementation of inheritance, Illustration of implementati...

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Frequecy count, how to calculate frequency count of algorithm

how to calculate frequency count of algorithm

Relational schema., pine vally company

pine vally company

Define single valued and multivalued attributes, Define single valued and m...

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

In how many parts events are classified, In how many parts events are class...

In how many parts events are classified Events are classified as four types in UML 1. Signals 2. Calls 3. Passing of Time 4. Change in State

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages