2018-08-03 13:09 GMT+02:00 R Smith <ryansmit...@gmail.com>: > Do you want a recursive query that will add all years between 3 October and > some other date, but NOT the first year and NOT the last year?
I want a recursive query that gives years to the start date until it reaches the end date or if it exceeds the end date, the last added date is valid. Meanwhile, it should report how many times it has added a year. Its output is the date of the last added year and the number of additions. Is this possible? -- Best, Pali _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users