SELECT b.CELL as CELL,b.DATE_ID AS 'DATE',count(b.CELL) as 'NO'
FROM (select a.eutrancelltdd as 'CELL',a.DATE_ID AS 'DATE_ID',a.HOUR_ID as 'HOUR',sum(pmErabEstabAttInit+pmErabEstabAttAdded) as 'Erab_Estab_Att',
round(100*sum(pmRrcConnEstabSucc)/(sum(pmRrcConnEstabAtt)+0.000001)*(sum(pmErabEstabSuccInit+pmErabEstabSuccAdded)/(sum(pmErabEstabAttInit+pmErabEstabAttAdded)+0.000001)),2) AS 'Radio_Est_Succ_R' from dc.DC_E_ERBS_EUTRANCELLTDD_RAW a) as b
WHERE DATEDIFF(DD,b.DATE_ID,GETDATE())=1 AND b.Erab_Estab_Att>50 AND b.Radio_Est_Succ_R<=95 AND (b.CELL like 'XNLF0080%')
GROUP BY b.cell,b.DATE,b.HOUR ORDER BY b.cell asc,b.DATE asc,b.HOUR asc
请问这样写结构有没有错,总是有问题,语法错在哪里。
因为原始表中时间单位是一刻钟,取出的是一刻钟符合条件的次数,但是现在想取出每小时符合条件的次数。