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