sql: convert from row to column

Question

0.00/5 (No votes)

See more:

Database:

C#

userID       Category
  1           Apple
  2           Apple
  2           Orange
  3           Apple
  3           Apple

Expected Result

C#

userID     Apple     Orange     Total
  1         1          0         1 
  2         1          1         2
  3         2          0         2

any idea how to build the Apple and Orange field? what function to use?

Posted 4-Dec-13 22:36pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-04T22:48:00

It is quite often asked question. Please, see:
MySQL pivot[^]
pivot tag:MySQL[^]

Posted 4-Dec-13 22:48pm