| 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 |
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