SELECT DATE_FORMAT(`INVOICE_DATE`, '%Y-%m') AS Month, SUM(TOTAL_COST), SUM(TOTAL_PROFIT), SUM(TOTAL_PROFIT) - SUM(TOTAL_COST) AS Profit FROM `invoice_table` WHERE DATE_FORMAT(`INVOICE_DATE`, '%Y') > 2000 GROUP BY DATE_FORMAT(`INVOICE_DATE`, '%Y-%m') ORDER BY Month ASC;Related Keywords: Developer, How-to, Solved, SQL Query
喜歡這篇文章嗎?
![1 粒星 1 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![2 粒星 2 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![3 粒星 3 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![4 粒星 4 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![5 粒星 5 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
(暫時未有評分)
Loading...
![1 粒星 1 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![2 粒星 2 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![3 粒星 3 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![4 粒星 4 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![5 粒星 5 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
(暫時未有評分)
![](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/loading.gif)