Data Science/DB+SQL
[MYSQL] Pivoting SELECT SQL ( Rows to Columns )
Sampe data 더보기 CREATE TABLE product_sales ( product_name VARCHAR(100), store_location VARCHAR(50), num_sales INT ); INSERT INTO product_sales (product_name, store_location, num_sales) VALUES ('Chair', 'North', 55), ('Desk', 'Central', 120), ('Couch', 'Central', 78), ('Chair', 'South', 23), ('Chair', 'South', 10), ('Chair', 'North', 98), ('Desk', 'West', 61), ('Couch', 'North', 180), ('Chair', 'S..
2022. 5. 11. 02:31
최근댓글