UC知道sybase数据库复杂查询
来源：百度知道 编辑：UC知道 时间：2024/06/27 15:36:22
给我更改一下查询语句，我想要按月分组查询！！在线等
select datepart(mm,StartTime) ,sum(ceiling(shichang/60)),COUNT(*),sum(shichang) from biao
where StartTime>='2009-01' AND mm,StartTime<'2009-09'
and Anumber like '0838%'
ORDER BY datepart(mm,StartTime)
select datepart(mm,StartTime) ,sum(ceiling(shichang/60)),COUNT(*),sum(shichang) from biao
where StartTime>='2009-01' AND mm,StartTime<'2009-09'
and Anumber like '0838%'
ORDER BY datepart(mm,StartTime)
select datepart(mm,StartTime),sum(ceiling(shichang/60)),COUNT(*),sum(shichang) from biao
where datepart(yy,StartTime) between 2009 AND 2009 and datepart(mm,StartTime) between 1 AND 9
and Anumber like '0838%' group by datepart(mm,StartTime)
ORDER BY datepart(mm,StartTime)
select datepart(mm,StartTime) ,sum(ceiling(shichang/60)),COUNT(*),sum(shichang) from biao
where datepart(year,StartTime)*10+datepart(month,StartTime)>=200901 AND datepart(year,StartTime)*10+datepart(month,StartTime)<=200909
and Anumber like '0838%'
ORDER BY datepart(mm,StartTime)