Sql Table data formation

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


Sql Table data formation



I have a below table


ID Level StoreId
2604553 3 A
2604553 7 C
2604553 7 D
2604553 7 E
2678540 3 A
2678540 7 A
2678540 3 B
2678540 7 B
2678540 3 C



I need out put like Below


ID A B C D E
2604553 3 0 7 7 7
2678540 3 3 3 0 0
2678540 3 7 3 0 0
2678540 7 3 3 0 0
2678540 7 7 3 0 0



Please help me how to achieve this.









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Makefile test if variable is not empty

Will Oldham

'Series' object is not callable Error / Statsmodels illegal variable name