I'm currently trying to form a SELECT query to from a table without using PIVOT.
Examples of data and expected result are shown below:
| Id | TYPE | Amount | | 1 | Deposit | 50 | | 2 | Withdraw | 10 | | 3 | Withdraw | 30 |
| Row | TYPE | Amount | TYPE | Amount | | 1 | Deposit | 50 | Withdraw | 10 | | 2 | - | 0 | Withdraw | 30 |
The deposits and withdrawals are not related to each other, just displaying in ascending order of id. The expected end result is two row of all deposits while another two row with withdrawals. The purpose of doing this is to maximize spaces.
Thought of using left join but there's no unique id that can let me use GROUP BY
Thanks in advance for helping.