You need a function which gives the week number. Note that this is calculated differently in the USA and Europe., so you need to use the correct rules to write the function.
Moshe Sharon wrote: > Hi > > How can I select ....group by week > > moshe > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users