请问是什么原因?该选择提交还是回退?执行的全是selecte语句
1、
select count(distinct(t.sfullnumber)) from E_LOGINLOG_201@Sdu_Link t where t.operatetime>='20161201090000'2、
select B.SDEPT as 部门ID,
C.sdepartmentname as 部门名称,
count(distinct(A.sfullnumber)) as 登录账号数
from E_LOGINLOG_201612@Sdu_Link A, E_BMP_MEMBER B, E_UC_DEPARTMENT C
where A.operatetime >= '20161201090000'
and A.sFullnumber = B.Sucaccount
and B.SDEPT = C.sdepartmentid
and C.ndeptlevel in (1)
group by SDEPT, sdepartmentname;
1、
select count(distinct(t.sfullnumber)) from E_LOGINLOG_201@Sdu_Link t where t.operatetime>='20161201090000'2、
select B.SDEPT as 部门ID,
C.sdepartmentname as 部门名称,
count(distinct(A.sfullnumber)) as 登录账号数
from E_LOGINLOG_201612@Sdu_Link A, E_BMP_MEMBER B, E_UC_DEPARTMENT C
where A.operatetime >= '20161201090000'
and A.sFullnumber = B.Sucaccount
and B.SDEPT = C.sdepartmentid
and C.ndeptlevel in (1)
group by SDEPT, sdepartmentname;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货