Skip to content
Advertisement

SQL Group by Transpose

I have the following Table charges

Using the following query gets my the counts by Charge and Date

Is there a way to transpose this to get the following?

Thank you.

Advertisement

Answer

Use conditional aggregation:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement