select case when c=1 then c else 0 end c1,case when c=1 then a else '' end a,case when c=2 then c else 0 end c2,case when c=2 then b else '' end b2,case when c=3 then c else 0 end c3,case when c=3 then b else '' end b3from aa order by a,b
显示全部select
case when c=1 then c else 0 end c1,case when c=1 then a else '' end a
,case when c=2 then c else 0 end c2,case when c=2 then b else '' end b2
,case when c=3 then c else 0 end c3,case when c=3 then b else '' end b3
from aa order by a,b
收起