Perform all selecte statement
1,
Select count (distinct (t.s fullnumber)) from E_LOGINLOG_201 @ Sdu_Link t where t.o peratetime>
='20161201090000'
2,
The select B.S DEPT as department ID,
C.s. departmentname as department name,
Count (distinct (A.s fullnumber)) as the login account number
A, the from E_LOGINLOG_201612 @ Sdu_Link E_BMP_MEMBER B, E_UC_DEPARTMENT C
Where A.o peratetime & gt;
='20161201090000'And A.s Fullnumber=B.S ucaccount
And B.S DEPT c.s. departmentid=
And C.n deptlevel in (1)
Group by SDEPT, sdepartmentname;
CodePudding user response:
Because there are dblink can have this hint, don't tube he, directly interrupt lineCodePudding user response: