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 to December.
Let's say that you want get a count of each DayNum.
For example, say the SQL is setup to grab 5 complete years of data. Since
there are no weekends included, this means that you are not necessarily
going to get:
DayNum(1) 5 total
DayNum(2) 5 total
DayNum(3) 5 total
etc.
Rather, if any particular day falls on a weekend, it won't be in the
dataset, so you may have:
DayNum(1) 5 total
DayNum(2) 4 total
DayNum(3) 4 total
DayNum(4) 3 total
etc.
How do I word my statement so that it gives me a count of each DayNum, which
is from 1 to 366?
Thanks.
Rick
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
