Select a, b,
The sum (case when c=10 then c else 0 end) as c_10,
The sum (case when c=11 then c else 0 end) as c_11,
The sum (case when c=12 then c else 0 end) as c_12
The from table1
Group by a and b

CodePudding user response:

Didn't know you specific data

CodePudding user response:

This is the share?

Thanks for sharing!

CodePudding user response:

ABC are

CodePudding user response:

字段