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 Interfaces for parametric Users? Interfaces for Parametric Users - Parametric users, such as bank tellers, frequent have a little set of operations in which they must p

Explain how the object classes are mapped to tables. Each object class maps to one or more than one tables in the database. The objects in the class may be partitioned horizont

Haw does it work one database application

what is object-identity

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

While sorting field groups we cannot use more than one key field False.

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name