sql查询两个日期之间的读取计数 [英] sql query for read count between two dates

问题描述

sql查询两个值之间的读取计数。



我正在使用下面的查询。但它只能检索个别日期计数。

sql query for read count between two values.

I am using bellow query. but it can retrieving only individual dates count.

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

我认为使用where子句应该没问题。试着看看。

Use the where clause should be ok i think. try and see.

这篇关于sql查询两个日期之间的读取计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！