## 2018-12-08 清理流水 ``` 清空及 lssjtemp lssj ``` ## ``` SELECT xffs FROM lssj WHERE (xfsj BETWEEN '2018-09-02 00:00:00' AND '2018-09-02 23:59:59') GROUP BY xffs ``` ``` SELECT * FROM lssj WHERE (xfsj BETWEEN '2018-09-02 00:00:00' AND '2018-09-02 23:59:59') AND (xffs = '因错退还') ``` ``` SELECT xfjh AS 消费机号, SUM(xfje) AS 消费金额 FROM lssj WHERE (xfsj BETWEEN '2018-09-02 00:00:00' AND '2018-09-02 23:59:59') AND (xffs = '菜单消费') GROUP BY xfjh ```