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

What is a database, What is a Database? To know what database is, we ha...

What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

What is oracle databse structure, What is Oracle databse structure? Or...

What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

What is assertion, What is assertion? Mention the forms available. An a...

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

Student database, tell me the functionality,advantages and disadvantages of...

tell me the functionality,advantages and disadvantages of student database

Normalization database, I need some help with my normalization database hom...

I need some help with my normalization database homework.

What is natural language interfaces, What is Natural Language Interfaces? ...

What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t

Transaction managenment, can you please explain with the help of suitable e...

can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

ER Diagram, Hi I have got an assignment for making an er diagram for market...

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

Ldb hierarchy there should exist one get statement, It is mandatory that fo...

It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False. It is not essential.

What is the use of unique function, What is the use of unique function? ...

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages