select EA_STATION_ID, EA_MONTH,EA_DATE,count(EA_DATE) from data group by EA_STATION_ID, EA_DATE,EA_MONTH having EA_DATE between 00 and 10
select EA_STATION_ID, EA_MONTH,EA_DATE,count(EA_DATE) from data WHERE EA_DATE between @DATE AND @DATE group by EA_STATION_ID, EA_DATE,EA_MONTH having EA_DATE between 00 and 10
Having
HAVING COUNT(EA_DATE) <= 10
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)