Rick Ratchford <r...@amazingaccuracy.com> wrote: > select > (select min(Year) ...) as firstFullYear, > (select max(Year) ...) as lastFullYear; > > If I go with the condensed version you illustrate above, I assume > that I would then need to use the LIMIT clause, right? When I tried > it, I get a bunch of rows returned, all with the same information. > > 1988 2008 > 1988 2008 > 1988 2008 > 1988 2008 > 1988 2008 > 1988 2008 > ... > > Here is the SQL used: > > Select (Select min(Year) From TmpTable Where Month=1 and Day<8) as > FirstYear, > (Select max(Year) From TmpTable Where Month=12 and Day>24) as > LastYear FROM TmpTable"
Do you see a FROM clause in my example? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users