看第一列的ID,前两行其实是相同的,保留第一行,去掉第二行。并把第二列的quantity相加。其余保留第一行的的所有信息,最后一行不变
之前是:
Invest ID | Quantity | Accrued Interest | SETTLE | INT | BB AI | Diff |
US55336TAC99_123 | 0 | 164,064.24 | 8/16/13 | 2.98298611 | 0 | 164,064.24 |
US55336TAC99_456 | 6,300,000.00 | 0 | 8/16/13 | 2.14027778 | 134,837.50 | -134,837.50 |
US428303AM35 | 0 | -68,250.00 | 8/17/13 | 2.275 | 0 | -68,250.00 |
需要变成这个样子:
Invest ID | Quantity | Accrued Interest | SETTLE | INT | BB AI | Diff |
US55336TAC99_123 | 6,300,000.00 | 164,064.24 | 8/16/13 | 2.98298611 | 0 | 164,064.24 |
US428303AM35 | 0 | -68,250.00 | 8/17/13 | 2.275 | 0 | -68,250.00 |
如何编写这样的SQL? Group by的话看其他列(例如Accrued Interest, INT)是不同的,所以没有办法。。
先谢谢了!