On 27/07/2009 12:16 PM, Rick Ratchford wrote:
> It's a seasonal map, so every year must overlay onto a 366 day grid.
>
> The table that contains the data has assigned each day a day number from 1
> to 366. If the year isn't a leap year, then day 60 will simply not be
> registered for that year.
F
years there is.
:-)
Rick
#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org
#>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Machin
#>Sent: Sunday, July 26, 2009 8:43 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] Little Help on SQL
On 27/07/2009 7:40 AM, Rick Ratchford wrote:
> I have a TABLE with a column of Day Numbers (1 to 366) called DayNum.
> Let's say that you want get a count of each DayNum.
> How do I word my statement so that it gives me a count of each DayNum, which
> is from 1 to 366?
Consider leap years ... d
Sent: Sunday, July 26, 2009 4:40 PM
#>To: 'General Discussion of SQLite Database'
#>Subject: [sqlite] Little Help on SQL
#>
#>Hello.
#>
#>I'm not yet there in my study of SQL with Rick's book, so I
#>thought someone might help me with an SQL query I need pr
Hello.
I'm not yet there in my study of SQL with Rick's book, so I thought someone
might help me with an SQL query I need pretty quick.
I have a TABLE with a column of Day Numbers (1 to 366) called DayNum.
I already have my SQL to where it will extract a number of complete years
from January
5 matches
Mail list logo