Kai Peters <kpet...@otaksoft.com> wrote: > given a table with two columns (SaleDate, SaleVolume) is it possible in one > query to obtain > the following three column result set: > > SalesCurrentYear, SalesLastYEar, SalesAllyears
select sum(SaleVolume * (SaleDate >= StartOfCurYear)) SalesCurrentYear, sum(SaleVolume * (StartOfLastYear <= SaleDate and SaleDate < StartOfCurYear)) SalesLastYear, sum(SaleVolume) SalesAllYears from Sales, (select date('now', 'start of year') StartOfCurYear, date('now', 'start of year', '-1 years') StartOfLastYear); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users