请问同样的代码在同样的日期出现了二个数字,我只要最大的那个数应该如何编程?谢谢!!如下:
| code | date | number |
| 600195 | 31-Dec-06 | 73639.55 |
| 600195 | 31-Dec-07 | 14670.75 |
| 600195 | 31-Dec-07 | 20141.11 |
| 600195 | 31-Dec-08 | 306841.3 |
| 600195 | 31-Dec-08 | 27933.37 |
| 600099 | 31-Dec-06 | 34212 |
| 600099 | 31-Dec-07 | 27781.49 |
| 600099 | 31-Dec-08 | 40854.2 |
| 600099 | 31-Dec-08 | 41764.71 |
| 600737 | 31-Dec-06 | 138475.5 |
| 600737 | 31-Dec-06 | 32701.26 |
| 600737 | 31-Dec-07 | 23282.85 |
| 600737 | 31-Dec-07 | 35783.09 |
| 600737 | 31-Dec-08 | 75743.66 |
| 600737 | 31-Dec-08 | 30069.04 |