10. Dynamic Pivoting of a Table

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Vote For New Content

10. Dynamic Pivoting of a Table

Table of Contents

Contents are not accessible

Problem

Table: Products

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| product_id  | int     |
| store       | varchar |
| price       | int     |
+-------------+---------+
(product_id, store) is the primary key (combination of columns with unique values) for this table.
Each row of this table indicates the price of product_id in store.
There will be at most 30 different stores in the table.
price is the price of the product at this store.

Problem Definition

Implement the procedure PivotProducts to reorganize the `Products

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible