分类显示，case when 处理null解决思路

分类显示，case when 处理null
[code=C#][/code]
ID Type Name Age
t1 100 A 14
t1 101 B 15
t1 102 C 15
t1 103 D 12
t2 100 A1 14
t2 101 B1 15
t2 102 C1 15
t2 103 D1 12
t3 100 A2 14
t3 101 B2 15
t3 102 C2 15
t3 103 D2 12
在sql 查询时 如何将上面的结果变成，用case when then 的时候 总会有很多NULL，是按 Type 分类的，

ID Name0 Age0 Name1 Age1 Name2 Age2 Name3 Age3
t1 A 14 B 15 C 15 D 12  
t2 A1 14 B1 15 C1 15 D1 12  
t3 A2 14 B2 15 C2 15 D2 12  


[解决办法]
select ID,max(case when type=100 then Name end) as Name0,max(case when type=100 then age end) as age0,
max(case when type=101 then Name end) as Name1,max(case when type=101 then age end) as age1,
max(case when type=102 then Name end) as Name2,max(case when type=102 then age end) as age2,
....
 from tt group by id
[解决办法]
case when co1 is null then 0 else col1 end
[解决办法]

SQL code

mysql> SELECT ID,MAX(CASE WHEN TYPE=100 THEN NAME END) AS Name0,MAX(CASE WHEN TYPE=100 THEN age END) AS age0,    -> MAX(CASE WHEN TYPE=101 THEN NAME END) AS Name1,MAX(CASE WHEN TYPE=101 THEN age END) AS age1,    -> MAX(CASE WHEN TYPE=102 THEN NAME END) AS Name2,MAX(CASE WHEN TYPE=102 THEN age END) AS age2,    -> MAX(CASE WHEN TYPE=103 THEN NAME END) AS Name3,MAX(CASE WHEN TYPE=103 THEN age END) AS age3    ->   FROM t4 GROUP BY id;+------+-------+------+-------+------+-------+------+-------+------+| ID   | Name0 | age0 | Name1 | age1 | Name2 | age2 | Name3 | age3 |+------+-------+------+-------+------+-------+------+-------+------+| t1   | A     |   14 | B     |   15 | C     |   15 | D     |   12 || t2   | A1    |   14 | B1    |   15 | C1    |   15 | D1    |   12 || t3   | A2    |   14 | B2    |   15 | C2    |   15 | D2    |   12 |+------+-------+------+-------+------+-------+------+-------+------+3 rows in set (0.01 sec)mysql>
[解决办法]
把你语句贴出来以供分析。否则别人无法找出你的错误在哪里。