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
What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

Determine the term- Active values An active value is that has dependent values. Every dependent value registers itself with active value that contains a set of dependent values

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.