SQL HELP PLEASE
Posted: Tue Mar 26, 2013 12:22 pm
Colin spoke of a limitation of the DISTINCT clause in SQL so there may not be a way to do what I seek but thought I would ask as I am sure many SQL experts around!
****** OK - the following works fine to list by month any month with over x number qsos for that month (500 in this example):
select year(date), month(date), count(*)
from log
WHERE Date BETWEEN #1/1/86# AND #2/28/13#
group by year(date), month(date)
HAVING COUNT(*) > 500
***** OK - the following works fine to list how many distinct DXCC in a given time frame (example is for July of 2004)
SELECT DISTINCT code FROM LOG where date between #7/1/04# and #7/31/04#
BUT - my question is: Is there an SQL that will list how many DXCC worked in a given time frame and then listed by month. You can use the above to get one total for any time frame but I would want a listing for each month and year (as with the qso query above) but for DXCC? For example to use the SQL to list any months in my log in which I worked over 100 DXCC?
Thanks for your thoughts on this question.
****** OK - the following works fine to list by month any month with over x number qsos for that month (500 in this example):
select year(date), month(date), count(*)
from log
WHERE Date BETWEEN #1/1/86# AND #2/28/13#
group by year(date), month(date)
HAVING COUNT(*) > 500
***** OK - the following works fine to list how many distinct DXCC in a given time frame (example is for July of 2004)
SELECT DISTINCT code FROM LOG where date between #7/1/04# and #7/31/04#
BUT - my question is: Is there an SQL that will list how many DXCC worked in a given time frame and then listed by month. You can use the above to get one total for any time frame but I would want a listing for each month and year (as with the qso query above) but for DXCC? For example to use the SQL to list any months in my log in which I worked over 100 DXCC?
Thanks for your thoughts on this question.