I wanted to sort all amounts by their respective currency.
Below is the output that i wanted.
I'm trying this code but it is not working. Hope you can help me to generate the output.
SELECT RefNumber, ProdCode, Amount, Currency,TraDate, AccOff
ORDER BY Currency
Thank you in advance.