Hi,
I have a oracle table.
Quarter | Account_Name | Account_Amount |
Q1 | A | 20,000 |
Q1 | B | 10,000 |
Q2 | A | 50,000 |
Q2 | C | 10,000 |
By querying the above table i want the below result. Any help is much appreciated
Q1_Account_Name | Q2_Account_Name | Account_Amount_Diff |
A | A | 50,000-20,000=30,000 |
B | | -10,000 |
| C | 10,000 |