Forum Discussion
Help in SQL Syntax
How to convert the below table1 into table2 using SQL? Please help.
table1
Year | Month | Amount
2001 | 1111 | 1.2
2001 | 1112 | 1.3
2001 | 1113 | 1.4
2002 | 1111 | 2.2
2002 | 1112 | 2.3
2002 | 1113 | 2.4
table2
Year | m11 | m12 | m13
2001 | 1.2 | 1.3 | 1.4
2002 | 2.2 | 2.3 | 2.4
No RepliesBe the first to reply