SQL hints
Posted: Tue Mar 05, 2013 5:17 am
I have found another SQL that works well for searching the log for hams that I have had over 'x' qsos with over the years! Neat as I have been trying to find that out for awhile.
This works: (30 qsos in this example)
SELECT callsign,COUNT(*) FROM log
GROUP BY callsign HAVING COUNT(*)>30
This works: (30 qsos in this example)
SELECT callsign,COUNT(*) FROM log
GROUP BY callsign HAVING COUNT(*)>30