如何将两条值合并成一条

Question

date	no	brand	m	money	sale	way
2014-03-28	1001	00	.0000	000.1200	A	CHG
2014-03-28	1001	00	.0000	439.0000	A	RMB
2014-03-28	2001	00	.0000	736.0000	A	RMB

怎么根据date把no一样的查询成一条值？
如

date	no	chg	rmb
2014-03-28	1001	.1200	439.0000

Answer 1

group by + 转置

如果想方便查询最好分2个表 一个无重复 一个详细记录

---

select date, no,
sum(if(way = 'CHG', money, 0)) as chg,
sum(if(way = 'RMB', money, 0)) as rmb
from table
group by date, no