ACCESS语句
select
format(day,'yyyy-mm-dd'),count(day)
from t
where
aa='07204'and datediff('d',day,'2011-3-1')<=0 and datediff('d',day,'2011-3-31')>=0
group by format(day,'yyyy-mm-dd')
sqlserver:
select
convert(nvarchar(10),day,23),count(*),max(eLevelSize)
from t
where
aa='07204' and datediff(d,day,'2011-3-1')<=0 and datediff(d,day,'2011-3-31')>=0
group by convert(nvarchar(10),day,23)
============
select
datepart(d,day) as d,count(*) as c,max(eLevelSize) as e
from t
where
aa='07204' and datediff(d,day,'2011-3-1')<=0 and datediff(d,day,'2011-3-31')>=0
group by datepart(d,day)
select
format(day,'yyyy-mm-dd'),count(day)
from t
where
aa='07204'and datediff('d',day,'2011-3-1')<=0 and datediff('d',day,'2011-3-31')>=0
group by format(day,'yyyy-mm-dd')
sqlserver:
select
convert(nvarchar(10),day,23),count(*),max(eLevelSize)
from t
where
aa='07204' and datediff(d,day,'2011-3-1')<=0 and datediff(d,day,'2011-3-31')>=0
group by convert(nvarchar(10),day,23)
============
select
datepart(d,day) as d,count(*) as c,max(eLevelSize) as e
from t
where
aa='07204' and datediff(d,day,'2011-3-1')<=0 and datediff(d,day,'2011-3-31')>=0
group by datepart(d,day)