Subject | Re: [IBO] Trouble with Count(*) |
---|---|
Author | Lucas Franzen |
Post date | 2004-04-15T23:00:23Z |
Eric,
even easier:
SELECT SiteID, Count (*) as NumStations
from StationInfo
GROUP BY SiteID
since you don't seem to need any further fields from SiteInfo.
Luc.
even easier:
SELECT SiteID, Count (*) as NumStations
from StationInfo
GROUP BY SiteID
since you don't seem to need any further fields from SiteInfo.
Luc.