Group By clauses

 • It is used to group database tuples on the basis of definite common attribute value like as employees of a department.

• WHERE clause still can be used, if required.

Example: Search department number and Number of Employees working in that department.

 SELECT DEPTNO, COUNT(EMPNO) FROM EMP

GROUP BY DEPTNO;

Please note that as using group by and aggregate functions the only attributes that can be put in select clause are the aggregated functions and the attributes that have been used for grouping the information. For instance, in the example 20, we cannot put ENAME attribute in the SELECT clause as it will not have a distinct value for the group. Please note the group here is formed on DEPTNO.

 

Posted Date: 3/11/2013 1:08:19 AM | Location : United States

Ask an Expert

Related Discussions:- Group by clauses-data manipulation language, Assignment Help, Ask Question on Group by clauses-data manipulation language, Get Answer, Expert's Help, Group by clauses-data manipulation language Discussions

Write discussion on Group by clauses-data manipulation language
Your posts are moderated

Write your message here..

Related Questions

Client dbms, i need to submit in this topic. i need to submit in this topic.

Query to delete constraint from alter table, A constraint named less_than_2... A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

HYRISE, how to implement hyrise in C plus plus how to implement hyrise in C plus plus

Project operation, The PROJECT operation The project operation is used t... The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

What is a linked server, What is a Linked Server? Linked Servers is a m... What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With

On laod, how to write a in a text and load it on mysql how to write a in a text and load it on mysql

The locking protocol, The Locking Protocol: To manage concurrency related ... The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

Consistency-transaction , Consistency: This property makes sure that a com... Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e

Normalisation, what is 3nf what is 3nf

We need help in booking system for golf business, We need help in Booking S... We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p