Skip to content
Advertisement

SQL query for group by result in different column [closed]

I Have table having 2 columns

I Want Result like

Is there any query or store Procdure to get such Output

Advertisement

Answer

You require DynamicSql + Pivot operation.I am not aware of any other method.

The below query will give you what you want.

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