select 名称,颜色,min(case 规格 when 'gg1' then 'gg1' end)) as 规格1,
min(case 规格 when 'gg2' then 'gg2' end)) as 规格2,
min(case 规格 when 'gg3' then 'gg3' end)) as 规格3
from tablename
group by 名称,颜色
min(case 规格 when 'gg2' then 'gg2' end)) as 规格2,
min(case 规格 when 'gg3' then 'gg3' end)) as 规格3
from tablename
group by 名称,颜色
select 名称,颜色,(case 规格 when condition1 then 规格 end) as 规格1,
(case 规格 when condition2 then 规格 end) as 规格2,
(case 规格 when condition3 then 规格 end) as 规格3
from tablename
select 名称,颜色,
sum(case 规格 when condition1 then 1 else 0 end) as 规格1,
sum(case 规格 when condition2 then 1 else 0 end) as 规格2,
sum(case 规格 when condition3 then 1 else 0 end) as 规格3
from tablename
group by 名称,颜色