sqlite查询按给定日期查找一年的总和 [英] sqlite query to find sum of a year by the given dates
本文介绍了sqlite查询按给定日期查找一年的总和的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我写了一个查询: SELECT YEAR(Date),SUM(replace(price,',',''))FROM FROM GROUP BY year(date);
。我正试图得到当年所有价格的总和,但我得到一个错误 - 没有这样的功能:年。请指导我。我是db中的菜鸟。再次感谢。
I have written a query : SELECT YEAR(Date),SUM(replace(price, ',', '')) FROM example GROUP BY year(date);
.I am trying to get sum of all price for that year but I am getting an error - no such function : year. Please guide me .I am a noob in db.Thanks again.
12/10/11 377,245.67
12/19/11 5,104,245.00
12/28/11 23,332.98
12/24/10 126,875.21
12/24/10 5,112,225.14
12/23/10 4,552.54
11/24/10 402.82
10/15/09 132,875.32
9/19/09 126,334,123.32
9/23/09 345,887.21
9/29/09 16,520.11
9/28/09 388,902.02
11/12/08 24,622.43
10/25/08 278,916.52
10/12/08 42.22
9/22/08 17,234.01
9/16/08 377,245.67
12/15/07 5,104,245.00
12/18/07 23,332.98
12/19/07 126,875.21
12/22/07 23,332.98
12/28/07 126,875.21
我要找的格式:
Year(Date) price
8 438483479.3
9 8774343479
10 5654389.34
11 5654354646
12 23434483479
推荐答案
试试这个
SELECT strftime('%Y', Date),SUM(replace(price, ',', '')) FROM example GROUP BY strftime('%Y', Date);
这篇关于sqlite查询按给定日期查找一年的总和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文