Seems my answer was a simple one after all. I only needed to be aware of GROUP BY.
Found it though. GROUP BY DayNum. Works. :-) Rick #>-----Original Message----- #>From: [email protected] #>[mailto:[email protected]] On Behalf Of Rick Ratchford #>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 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 #> #> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
