select id, (case when id1=0 then '实' else '虚' end) id1, case when id2=0 then '大' else '小' end) id2, case when id3=0 then '弱' else '强' end) id3 from tablename group by id
select id, (case when id1=0 then '实' else '虚' end) id1, (case when id2=0 then '大' else '小' end) id2, (case when id3=0 then '弱' else '强' end) id3, from tablename
(case when id1=0 then '实' else '虚' end) id1,
case when id2=0 then '大' else '小' end) id2,
case when id3=0 then '弱' else '强' end) id3
from tablename
group by id
(case when id1=0 then '实' else '虚' end) id1,
(case when id2=0 then '大' else '小' end) id2,
(case when id3=0 then '弱' else '强' end) id3,
from tablename