What is Pivot table in DBMS?? Please tell me with an example. If you can tell me with example then it's nice otherwise I don't have any problem if you don't have an example: )
Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns.it allows grouping by any field (column), and using advanced calculations on them.
Answers & Comments
Explanation:
Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns.it allows grouping by any field (column), and using advanced calculations on them.
hope you like it army ⟬⟭