sqlite query to find sum of a year by the given dates

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

Format I am looking for:

Year(Date)               price
8           438483479.3
9           8774343479
10          5654389.34
11          5654354646
12          23434483479

Answers


try this

SELECT strftime('%Y', Date),SUM(replace(price, ',', '')) FROM example GROUP BY strftime('%Y', Date);

I suggest this sintax:

SELECT strftime('%Y',Date), SUM(replace(price, ',', '')) FROM example GROUP BY strftime('%Y',Date);

Hope it helps


Need Your Help

Can I use JPEG compression for images in pdf files generated on iOS?

iphone ios ipad pdf

Currently I am dealing with the problem that I have pdf file with lots of 1024x768 images in it and am trying to optimize the pdf's file size, but the only solution that I thought is good enough fo...

Convert a function to delegate

function delegates d d2

I have a property that accepts a delegate: http.onReceiveHeader = (in char\[\] key, in char\[\] value) { }. I want to use a separed function instead of, e.g:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.