How can we transpose a table using SQL (changing rows to column or vice-versa) ?

Technology CommunityCategory: SQLHow can we transpose a table using SQL (changing rows to column or vice-versa) ?
VietMX Staff asked 3 years ago

The usual way to do it in SQL is to use CASE statement or DECODE statement