sql高手请来，谁能一条sql查出这样的结果？

Question

table[student]

id	name	date	money
1	张三001	20140501	10
2	张三002	20140502	20
3	张三003	20140503	30
4	张三004	20140504	40
5	张三005	20140505	50
6	张三001	20140502	15

查询结果：

id	name	20140501	20140502	20140503	20140504	20140505
1	张三001	10	15
2	张三002		20
3	张三003			30
4	张三004				40
5	张三005					50

Answer 1

with t1 as
(select distinct name from student)

select t1.name,
(select money from student s where s.date = '20140101' and s.name = t1.name),
(select money from student s where s.date = '20140102' and s.name = t1.name),
(select money from student s where s.date = '20140103' and s.name = t1.name)
from t1