select * from  (select min(DATETIME) DATETIME,businessType,sum(ULLEN) ULLEN,sum(DLLEN) DLLEN,sum(PKTCOUNT) PKTCOUNT,sum(ERRORCOUNT) ERRORCOUNT,round(sum(0),2) ULAVGSPEED,round(sum(0),2) DLAVGSPEED,round(avg(AVGTIMES),2) AVGTIMES,max(MAXTIMES) MAXTIMES,nvl(round(sum(IPLEN),2),0) IPLEN, 0 ERRORCOUNTrate,count(1) CONNCOUNT from (select  min(DATETIME) DATETIME,businessType,nvl(round(sum(ULLEN/1024/1024),3),0) ULLEN,nvl(round(sum(DLLEN/1024/1024),3),0) DLLEN,sum(PKTCOUNT) PKTCOUNT,sum(ERRORCOUNT) ERRORCOUNT,round(sum(ULAVGSPEED)/720,2) ULAVGSPEED,round(sum(DLAVGSPEED)/720,2) DLAVGSPEED,round(avg(AVGTIMES),2) AVGTIMES,max(MAXTIMES) MAXTIMES,nvl(round(sum(IPLEN/1024/1024),3),0) IPLEN, 0 ERRORCOUNTrate from newtest_business1 where 1=1  and DATETIME>to_date('2012-10-17 10:00:00','YYYY-MM-DD HH24:MI:SS') and DATETIME<=to_date('2012-10-18 10:00:00','YYYY-MM-DD HH24:MI:SS') and businessType is not null  group by businessType,userid) group by businessType order by DLLEN DESC) where rownum<=10
请帮忙看看
在C#里面的错误是 ORA-00904: "USERID": invalid identifier