SQL HELP PLEASE

You may post here if you are having problems with Winlog32 that others may be able to help you with. You may also report bugs so that the author may act upon them.
Post Reply
N5PHT
New user
Posts: 2
Joined: Thu Feb 28, 2013 7:06 am

SQL HELP PLEASE

Post by N5PHT »

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.
Post Reply