使用left函数作为分组条件即可 :天:left(theDate,10) 月:left(theDate,7) 年:left(theDate,4)select count(*) from tablename where 1 group by left(theDate,10)/ left(theDate,7)/left(theDate,4) 试试看,应该可以
每日 select count(*), left(dt,10) tt from b group by left(dt,10) 每月 select count(*), left(dt,7) tt from b group by left(dt,7) 每年 select count(*), left(dt,4) tt from b group by left(dt,4)
月:left(theDate,7)
年:left(theDate,4)select count(*) from tablename where 1 group by left(theDate,10)/ left(theDate,7)/left(theDate,4)
试试看,应该可以
每日
select count(*), left(dt,10) tt from b group by left(dt,10)
每月
select count(*), left(dt,7) tt from b group by left(dt,7)
每年
select count(*), left(dt,4) tt from b group by left(dt,4)