取每个顾客消费满50、满100时的日期
表如下图:
name | costdate | num |
jack | 2015-01-01 | 10 |
tony | 2015-01-02 | 15 |
jack | 2015-02-03 | 23 |
tony | 2015-01-04 | 29 |
jack | 2015-01-05 | 46 |
jack | 2015-04-06 |
取每个顾客消费满50、满100时的日期
表如下图:
name | costdate | num |
jack | 2015-01-01 | 10 |
tony | 2015-01-02 | 15 |
jack | 2015-02-03 | 23 |
tony | 2015-01-04 | 29 |
jack | 2015-01-05 | 46 |
jack | 2015-04-06 |