answersLogoWhite

0


Best Answer

Let's start with the GROUP BY clause. You can use this to group values from a column, and, if you wish, perform calculations on that column. Let's look at a simple example:

mysql> SELECT poet,SUM(copies_in_stock) FROM writer GROUP BY poet; +----------------------+----------------------+ | poet | SUM(copies_in_stock) | +----------------------+----------------------+ | Douglas Livingstone | 23 | | Mongane Wally Serote | 13 | +----------------------+----------------------+

by

m.sathyam reddy

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is grouping in DBMS?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is de-normalisation in dbms?

Hi, Denormalisation is the process to read the performance by adding redundancy of data or by grouping of data.


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


What are three types of dbms?

Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What are the importance of dbms in industrial environment?

importance of DBMS


What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.


What is the use of dbms?

DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)


When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.


What is DBMS?

DBMS is short for database management system . DBMS is the collection of related records.