select count(1) over() as tcnt,
rownum as rn,
O.CustomerID,
O.CustomerName,
O.CustomerType,
O.CertType,
O.CertID,
O.MFCustomerID,
O.MCCustomerID,
getManageUserID(O.CustomerID) as ManageUserID,
getManageOrgName(O.CustomerID) as ManageOrgName,
getManageUserName(O.CustomerID) as ManageUserName,
O.Private,
O.Isresure,
getcustomerbalance3(O.CustomerID) as Balance
from customer_info O
where 1 = 1
and (exists (Select 'X'
From IND_INFO II
Where O.CustomerID = II. CustomerID
and II.UpdateDate = '2019/06/26'
and II.UpdateUserID = '017634') or exists
(Select 'X'
From ENT_INFO EI
Where O.CustomerID = EI.CustomerID
and EI.UpdateDate = '2019/06/26'
and EI.UpdateUserID = '017634
SQL优化之FILTER
最新推荐文章于 2024-06-10 18:51:22 发布