What is grouping in DBMS?

Answer 1

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