Transposing Rows data into Columnar form
Question
Q: We have CUSTOMER table having columns as Customer_Name, Merchant_name (Amazon, Flipkart, Myntra etc.) and
Transaction_value (Purchase value for each of these merchants). Write a query to Transpose this into Customer Name,
Merchant Names as individual columns and their transaction value for each of the customers
in progress
0
SQL
3 years
0 Answers
585 views
Newbie 0
Leave an answer