What is the use of group by clause, Database Management System

What is the use of group by clause? 

Group  by  clause  is  used to apply  aggregate  functions  to a  set  of  tuples. The attributes given in the group by clause are used to form groups. Tuples with the similar value on all attributes in the group by clause are placed in one group

 

Posted Date: 7/27/2013 7:11:44 AM | Location : United States







Related Discussions:- What is the use of group by clause, Assignment Help, Ask Question on What is the use of group by clause, Get Answer, Expert's Help, What is the use of group by clause Discussions

Write discussion on What is the use of group by clause
Your posts are moderated
Related Questions
Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

What are the factors to be taken into account when choosing a RAID level? A) Monetary cost of extra disk storage requirements. B) Performance requirements in terms of number

Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Which two tools are used to administer users for Active Directory?

Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Object-oriented decompositions Object-oriented decompositions of systems better are able to cope with change. Each subsystem has a well-defined interface which communicates with