You're a genius Igor. Thank you very much! Much easier than what I was thinking.
Rick -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: Wednesday, July 08, 2009 12:40 PM To: [email protected] Subject: Re: [sqlite] Getting Complete Years Only Rick Ratchford <[email protected]> wrote: > Can someone help me with a SQL request? > > The Table contains Date, as well as Year, Month and Day columns. > > I would like to return a recordset that is made up of only COMPLETE > YEARS, from January to December. > > Say my data starts on August 14, 1975 and ends with May 4, 2009. > > How do I get just those records that start from January 1, 1976 to > December 31, 2008, as those would be the only COMPLETE YEARS from > January to December in my table? Perhaps something like this: select * from myTable where Year between (select min(Year) from myTable where Month=1 and Day=1) and (select max(Year) from myTable where Month=12 and Day=31); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
