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 the need for the bcnf normal form, Surgeons identified by doctor ID...

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

Distributed transaction atomic-consistent-isolated, A distributed transacti...

A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers m

Database management system, Distributed Database Management System

Distributed Database Management System

DBMS, give some example real life situation where DBMS are most suitable

give some example real life situation where DBMS are most suitable

Case study, what problems are raised by the database? why is it so controve...

what problems are raised by the database? why is it so controversial? why is data quality an issue?

advantages of database over file system, Q. Why would you choose a datab...

Q. Why would you choose a database system instead of simply storing data in operating system file? Define at a base concept in details. Sol. Advantages of Database over Fil

Explain hashing techniques, Explain Hashing techniques The hashing tech...

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

Analyzing association traversal, Analyzing Association Traversal Assoc...

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

What are advantages of object models, What are advantages of object models?...

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

Types of fragmentation, vertical fragmentation

vertical fragmentation

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages